Criteria for a query

[Karen]

I have a form that allows you to select an emp # and then
select a command button that runs a query.

I am creating the query but I don't know how to get the
information from the form and run the query based on the
certain emp # selected from the form?

I think I have to put some sort of code in the criteria
section?

Thanks for any help..

 

[Michael Hopwood]

If your form is called "frmEmployees" and your control is called "txtID"
(because it's a text-box) then put this in the criteria of your query:

[Forms]![frmEmployee]![txtID]