Parameter query using combo boxes adding a filter

[Guest]

Hello!

I am using combo boxes (4) to populate the criteria for a query. Users can
select by Industry (legal, medical, computer, etc) Occupation (programmer,
doctor, attorney ...) Type (corp, individual, partnership...) and City. The
users now want to use the first three, and have City as a filter, (AND rather
than OR), but only if they select a city. For example, they might want to see
ALL doctors regardless of city, then they might want to see doctors within a
particular city.

I know that I should know how to do this, however my brain can not seem put
it together today.

Thank You for your help

 

[Guest]

In your query add the following on each criteria row under field for city --
Like [Forms]![YourForm]![ComboBoxCity] & "*"

 

[Guest]

Thank You Karl!

In your query add the following on each criteria row under field for city --
Like [Forms]![YourForm]![ComboBoxCity] & "*"

Hello!

I am using combo boxes (4) to populate the criteria for a query. Users can
select by Industry (legal, medical, computer, etc) Occupation (programmer,
doctor, attorney ...) Type (corp, individual, partnership...) and City. The
users now want to use the first three, and have City as a filter, (AND rather
than OR), but only if they select a city. For example, they might want to see
ALL doctors regardless of city, then they might want to see doctors within a
particular city.

I know that I should know how to do this, however my brain can not seem put
it together today.

Thank You for your help