query using a list box

[Lauren B]

I have a list box ("LstBx1") on my "Query_Page" containing all states (by
abbreviation) in the United States. I have the box set up so the user can
select more than one state. I am attempting to write a query that it will
display all customers based on the state(s) indicated by the user on a
separate form.

If the list box were a combo box allowing only one selection, I will put the
criteria for the State field in the query as: [Forms]![Query_Page]![LstBx1]
However, this does not seem to work for the list box allowing multiple
selections. What is the best way to re-write this statement?

Thank you in advance for any assistance.

LB

 

[Guest]

Lauren,

You will need to build the SQL for the query dynamically. Check out this
site (http://www.microsoft-accesssolutions.co.uk/query_using_listbox.htm) for
an explaination.

HTH
Dale

 

[Van T. Dinh]

See also The Access Web article:

http://www.mvps.org/access/forms/frm0007.htm