listbox multiselect

[stevedi]

Hi,

I have a listbox on a form that I use to filter records using a select query. I use [Forms]![theForm]![ListName] as criteria in the select query. The query runs and returns records if the listbox multiselect property is set to none. I would like to be able to make multiple selections in the listbox this having multiple OR criteria in the select query. However when I set the multiselect property to Simple or Extended the query runs but no records are returned.

Any thoughts as to what's going on would be appreciated.

Thanks
SteveD

 

[PaulBricker]

This post is getting a lot of miles. Look at the stuff Bob posted.
Paul

thread701-473531