query criteria

[jena90]

I am designing a query in an access database (office version 2000). One of
the fields in the query is "department". In my form there is a pull down menu
with about 20 departments. In my query, I am making the department field have
a criteria so that when you run the query, it asks for which department.
However, if you do not type the department name exactly as in the list, you
do not get any matches. Is there any way when running a query with a criteria
to have it ask for a field but show a pull down menu when it asks...so that
you don't necessarily have to know exactly how something is spelled?

 

[Marshall Barton]

I am designing a query in an access database (office version 2000). One of
the fields in the query is "department". In my form there is a pull down menu
with about 20 departments. In my query, I am making the department field have
a criteria so that when you run the query, it asks for which department.
However, if you do not type the department name exactly as in the list, you
do not get any matches. Is there any way when running a query with a criteria
to have it ask for a field but show a pull down menu when it asks...so that
you don't necessarily have to know exactly how something is spelled?

Better to avoid those popup prompts altogether. Instead,
use a form eith a combo box to select the department and a
command button to open the report. You can then use the
OpenReport method's WhereCondition argument to provide the
criteria.