combo box in query 1

[tomf]

I am developing a small application for internal project tracking. I designed a query that I use when generating reports. In this query I prompt the user to enter the project engineer, using the following for the criteria:<br>
<br>
[Enter Engineer]<br>
<br>
Instead of having the user enter the engineer, I would like to have a combo box display, and the user would select an engineer from the list (or use the * wildcard for all engineers). Any suggestions.<br>
<br>
Thanks,<br>
Tom F

 

[elizabeth]

Do you have the &quot;Solutions.mdb&quot; that comes with Access97? There is an example of just what you're looking for, under Category &quot;Work with combo boxes...&quot; and Example &quot;Add [All]&quot; to List&quot;.