Linking Forms-Auto Populate Form A to Form B

[Holli]

Hi,


I have created an auto populated drop down for the user data entry Form. The user clicks their employee ID their First Name, Last Name and Department appear in the corresponding fields.
This is the code in Form A.

Private Sub EMP_ID_Change()


Me.txtFirst_Name.Value = Me.EMP_ID.Column(1)
Me.txtLast_Name.Value = Me.EMP_ID.Column(2)
Me.txtDepartment.Value = Me.EMP_ID.Column(3)
Me.txtLocation.Value = Me.EMP_ID.Column(4)
End Sub

What I would like to do is link Form A to Form B when the user clicks their employee ID in Form A it will auto populate in Form B.

Thanks

Holli

[June7]

VBA is not necessary to display these values in textbox. Expression in ControlSource property could be:

=[EMP_ID].[Column](1)

Are Form A and Form B in form/subform arrangement? Have you set the subform container Master/Child Links properties?

[Holli]

Thanks June 7

No they are not in form/subform arrangement. Originally they where separate main forms, but my boss wanted them to be rolled together. I created a Button(Macro) now he doesn't want the employee to have to select their employee ID for each form.

Holli

[June7]

If these forms have a dependent relationship, set the Master/Child Links properties to the PK/FK fields. The PK will automatically populate into the subform record.

[Holli]

They don't have a dependent relationship. They are separate data entry forms (survey questions)

Thanks

Holli

[June7]

I don't understand the data structure. If you want to provide db for analysis, follow instructions at bottom of my post.

Requires code to pass data between unlinked forms. Several ways to accomplish. Which one to use depends on structure of forms and how you want them to behave.

One way is code in Open or Current event of Form B that refers to open Form A

If Me.NewRecord Then
Me.EmpID = Forms!FormA!EmpID
End If

[Holli]

Great Thanks June 7