I have a form with a subform. the main form has company Id(key feild) with other information and a empty txtbox I put in. The subform is linked by company ID but also have employee ID(key feild) and employee name.

What I want to do is on the main form's txtbox put in the employees id from the subform and hit enter, then the that employees's individual employee form opens up.

Any help!!!

In the EmployeeID field in the subform put code similar to this on the On Click or On Dbl Click event:

DoCmd.OpenForm "frmEmployees", , ,"[EmployeeID] = " & Me.EmployeeID

Then a click or double click in the EmployeeID field will open the Employee form to the correct Employee. Be sure and change the fields above to the ones you use in your database.

Thank you it worked...:-)

Glad to see you back_Jack. Hope you where untouched by the recent lunancy.