issue exporting item from List boxes

[Brigitt]

Hello,

I have encountered a problem while I have been working on the form.
The form contains 3 list boxes. (not combo boxes, because with combo I cannot select more items)


When I select "PartnerA" from list1, list2 is goint to show those items belong to "PartnerA".
My goal is once I have finished all selection, export items according to the selection into an excel sheet. I created a macro, and linked it with a query where above explained selection is defined.
My problem is, if I select "PartnerA" from list1 but I do not make any selection from list2, it works properly, BUT if I make any selection from list2 too, I get an empty spredsheet. What could cause this issue?
Thanks in advance!
Brigitta

[NoellaG]

Hi,

probably something wrong in your query in the combination of AND and OR statements. How do you build your SQL statement?

gr
NG

[Brigitt]

Hi,

probably something wrong in your query in the combination of AND and OR statements. How do you build your SQL statement?

gr
NG

Hi NG,

Thanks for your reply, indeed there was a prblem in the SQL, I have mixed up two field, and could not find out the reason my form did not work.... now I have stucked again, but with an other issue.
I have almost finished my form but there is one issue I cannot find the solution. My form consist more list boxes. If I select sg from List1, the list2 will be automatically updated with records belong to list1. I select and item from list2, the list3 will then updated....etc. I used list box instead of combo because there is a possibility to select more than 1 item from the list.
BUT if I select eg: 2 or more items (eg A, B, and C) from list1, all items from list2 disappear. I would expect, in this case all records in list2 will be shown which belong to A, B, and C. but List2 is empty instead. Do I miss some definitions from SQL?
thanks any advice ahead!
Brigitta