Choosing variables to sort by

[Tom Ellison]

Dear Jeff:

The prompt using the syntax like your:

[ Enter Job Name ]

always uses a text box. There is no way to modify this to be a combo box
populated with only the valid values.

To do this, you should use a form. Put a combo box there whose rowsource
provides the valid values. Reference this from your query (works for MDBs)
or dynamically create the code for the query.

 

[Guest]

Currently I have a query that will do a sort when you type in the Job Name.
But if you don't type in the name 100% correct it will not sort correctly.
Is there a way so that when the box appears on the screen that a person could
go through a scroll down of possible name choices that they could select and
then the query would show the results.

Current code
SELECT Production.*, Production.[Job Name]
FROM Production
WHERE (((Production.[Job Name])=[ Enter Job Name ]));


Thank you