I am designing a query. 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?
April 24, 2008 12:08 PM
October 10, 2008 6:44 PM