Populating combobox with query (and pick form list?)

[Guest]

I am using combobox1 to filter values in combobox2 by way of a dynamic SQL
statement (modifying WHERE clause).

Combobox1 is populated by a query on formLocations and contains Location1,
Location2...

How do I put the option "All locations" in combobox1?

It's as if I need to populate the combobox form a query and pick form a list
as well.

Thanks for any help.
Seth

 

[Guest]

If what you asking for is, if the user doesn't select anything in combo1 then
you want to display in combo2 all the records, then use the like statment

"Where Location Like '" & nz(me.combo1Name),"*") & "'"