FORMS: Open New Form, Show data from Previous Employee

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.

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.

--
HTH
Van T. Dinh
MVP (Access)



"franklinbukoski" wrote in
message ...
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.