Query parameter

[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

 

[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.