Use textbox to show ALL values in a query

[echorley]

I have a table with various school names and a form with a combo box with these school names. I can easily select a single school and the query will show only the data for that school building.

How do I set up the combo box or the criteria in the query if I want the query to show ALL of the buildings?

I have tried the following where I select the word "ALL" in the combo box and then the following text is automatically inserted into the text box txtChooseBuilding:

Me.txtChooseBuilding = "Central" Or "Gates" or "Hill"

Then I set the criteria in the query to point to this field on my form, but the query came up empty.

Even better would be a list box where I could select which buildings I want. However, the query criteria seems a bit tricky with a list box.

 

[pbaldy]

You could use this technique:

http://www.mvps.org/access/queries/qry0001.htm

I use this for a listbox:

http://www.baldyweb.com/multiselect.htm