Query parameter

Z

Zb Kornecki

Is there a way to have a query parameter give the user a combo box of the
available choices. I want the user to pick a name from a list instead of
typing it in.
thanks Zb
 
K

KARL DEWEY

Use the combo on a form with source from a separate table or form table the
has good entries.
SELECT EmpID, Name FROM YourTable GROUP BY EmpID, Name;

If it is from a separate table then you would not need the group by part.
 
Top