Query parameter

  • Thread starter Thread starter Zb Kornecki
  • Start date Start date
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
 
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.
 
Back
Top