Feb 3, 2004 #1 zahadhum Programmer Feb 3, 2004 2 GB Hi, I want to produce a query in Access 2000 based on a number of values selected in a listbox with multiselect (1) I've tried all sorts of methods, even coding, but are unable to produce a result.
Hi, I want to produce a query in Access 2000 based on a number of values selected in a listbox with multiselect (1) I've tried all sorts of methods, even coding, but are unable to produce a result.
Feb 3, 2004 #2 cghoga Programmer Jun 26, 2003 614 US You need a For Each...Next structured loop. Like below. Dim var as variant For Each var in YourListBoxName.ItemsSelected 'Run your query here. Next var Make sure the Multi Select property is set to Simple or Extended. Hope this puts you on the right track. Upvote 0 Downvote
You need a For Each...Next structured loop. Like below. Dim var as variant For Each var in YourListBoxName.ItemsSelected 'Run your query here. Next var Make sure the Multi Select property is set to Simple or Extended. Hope this puts you on the right track.
Feb 3, 2004 #3 dhookom Programmer Jun 24, 2003 22,536 US Try this faq703-3936. If you have any questions, come on back. Duane MS Access MVP Find out how to get great answers faq219-2884. Upvote 0 Downvote
Try this faq703-3936. If you have any questions, come on back. Duane MS Access MVP Find out how to get great answers faq219-2884.