FORMS: Open New Form, Show data from Previous Employee

[Guest]

I would like to click a button on one form that automatically shows me
additional data on the same employee I was just looking at in the first form.

My first form enables me to edit employee data, but sometimes when I update
their information I need to see every other pending action that is tracked
against the employee, so when I open the new form I'd like it to display all
of this associated data, without having to reenter the employee's SSN.

 

[Van T. Dinh]

Use the "wherecondition" argument in the OpenForm method to filter the
second/called form to only the current employee on the calling form.

Check Access VB Help on the OpenForm method.