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
KARL DEWEY - 12 Jul 2005 21:15 GMT
In your query add the following on each criteria row under field for city --
Like [Forms]![YourForm]![ComboBoxCity] & "*"
> Hello!
>
[quoted text clipped - 10 lines]
>
> Thank You for your help
Kirk Leader - 12 Jul 2005 21:26 GMT
Thank You Karl!
> In your query add the following on each criteria row under field for city --
> Like [Forms]![YourForm]![ComboBoxCity] & "*"
[quoted text clipped - 13 lines]
> >
> > Thank You for your help