How to make a form uploading the same data form original form to o

[Guest]

Hi,
I have to forms, all employees’ list form and display employee data form.
What I need is how can make the display employee data form to upload the same
data which is being chosen from the “all employees list form†for the
specific employee to “Display employee data formâ€
Your cooperation is highly appreciated
Thx.

 

[Larry Linson]

Hi,
I have to forms, all employees' list form and display employee data form.
What I need is how can make the display employee data form to upload the
same
data which is being chosen from the "all employees list form" for the
specific employee to "Display employee data form"
Your cooperation is highly appreciated

If you have a Field which uniquely identifies the Employee Record (for
purposes of illustration, call it EmployeeID, and make certain it is
included in the RecordSource of the "All Employees List Form"). In the
Double-Click event of each Control displayed in the continuous-forms view of
the "All Employees List Form" and in the background area visible around
those Controls, put VBA code similar to the following.

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

where you replace "frmEmployeeDataDetail" with the name of your "Display
employee data form".