7 7anthala Registered User. Local time Today, 07:16 Joined Apr 7, 2014 Messages 41 Apr 25, 2014 #1 i need to know how to get the multi value from list box in my form to be used in a query the list box worked great when it was not multi value
i need to know how to get the multi value from list box in my form to be used in a query the list box worked great when it was not multi value
pbaldy Wino Moderator Staff member Local time Yesterday, 21:16 Joined Aug 30, 2003 Messages 36,176 Apr 25, 2014 #2 If it's to open a form/report: http://www.baldyweb.com/multiselect.htm
7 7anthala Registered User. Local time Today, 07:16 Joined Apr 7, 2014 Messages 41 Apr 26, 2014 #3 i want the multi value list box to be a query criteria
C CJ_London Super Moderator Staff member Local time Today, 05:16 Joined Feb 19, 2013 Messages 16,993 Apr 26, 2014 #4 You can't use it directly in a query. Use Pauls code to build the Where string in the listbox afterupdate event- you can then assign string a subform filter or use docmd.execute or use it in the WHERE parameter for docmd.openform or or openreport
You can't use it directly in a query. Use Pauls code to build the Where string in the listbox afterupdate event- you can then assign string a subform filter or use docmd.execute or use it in the WHERE parameter for docmd.openform or or openreport