After Update = EmployeeID.column(2)

[Frank]

I have one field called EmployeeID and I show three columns, (EmployeeID,
Last_Name, and First_Name) from a linked table.
I would like to auto fill the Employee_last_name in my Employee_Last_Name
field when the EmployeeID is selected.

Thank you

Frank

 

[Klatuu]

How is the employee id selected?

 

[Frank]

I posted to soon, I found the answer shown below and it works great.

Private Sub EmpoyeeID_AfterUpdate()
Me.Employee_Last_Name.Value = Me.EmployeeID.Column(1)
End Sub