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

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

Post by Z2hvc3 » Tue, 06 Feb 2007 16:16:00

Hi,
I have to forms, all employeeslist 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 ll employees list formfor the
specific employee to isplay employee data form Your cooperation is highly appreciated
Thx.

 
 
 

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

Post by Larry Lins » Wed, 07 Feb 2007 07:06:47


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".