Query Based on a List Box

[cjspsx]

I need to base a query on multiple selections of a list box. I have my list box based on a table. I have a query with Forms!frmName!lstboxName in the criteria. I have a button on the form linked to the query so that when selections are made, I can run the query. The problem is that when the query is run, there are 0 records. The criteria isn't being passed somehow. What am I doing wrong?

Thanks,
cj

 

[DreamerZ]

I think you actually need the ItemData property. The ListBox Name just returns the name of the ListBox, so your query is looking for that name and not the selections. Also, you might need to create an array of the selections to set the query criteria.

I have some code that does that, so let me know if you need it.


DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]