Parameter query using combo boxes adding a filter

K

Kirk Leader

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
 
K

KARL DEWEY

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

Kirk Leader

Thank You Karl!


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

Kirk Leader said:
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
Click to expand...
Click to expand...
 
Top