Going from Parent to One Record in Full Recordset

[esipp]

I have 2 forms: Employee List and Employee Info

I want to be able to select an employee in my combo box on Employee List form, then click a hyperlink/button and go to THAT employee's information on Employee Info.

The CAVEAT: I want to have the FULL recordset for Employee Info form(i.e. i do not want to query Employee Info form to include only one employee), I just want the one I am looking for to be the FIRST ONE TO SHOW UP.

Please Help!

PS: I'd love for the method to tie primary keys like [EmployeeID] = Forms!...[EmployeeID]

 

[wiltshire]

I do this using a macro - but you may know how to do it in VB

choose the record in form one, then, on click of a button, run a macro that opens the second form, then in the actions column of the macro use GOTO CONTROL to go to the appropriate field on the second form, then FIND RECORD to go to the correct record (it has filters where you can say 'the same as the field on form one')

This takes you to the right record, but not just one record, it shows all of them, but just goes to the one you want.

hope this helps