Criteria for a query

  • Thread starter Thread starter Karen
  • Start date Start date
K

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..
 
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]
 
Back
Top