Populating combobox with query (and pick form list?)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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),"*") & "'"
 
Back
Top