Create query to open a record in a form?

[ITguy1981]

I was wondering, is it possible to open a form to a specific record base on criteria in a query? Right now I have a form with basic employee information. I can create a query to enter employee name as the criteria and it will open the record, but it opens in table view. I would like for it to open my employee form and go to that record instead.

 

[bob fitz]

Perhaps you could use your query as the Record Source of the form.
I would usually open the form with all records and have a combo box in the header section which, after a selection has been made, moves the focus to that record.

 

[ITguy1981]

That is a good option. My original plan was to bind the query to a button on the main switchboard so the user could easily click the button, enter the name in a prompt, and then have the form open to the record that matches the criteria that was entered in the prompt.

 

[ITguy1981]

I used a query adding the "*" field from my table and "employee name" field. In the criteria for "employee name" I used, Like "*" & [Enter all or part of employees name] & "*". It works perfectly. Thank you.