autofill

[Guest]

Help - This code is suppost to look for the Employee Number chosen in the
Employee Number Combo Box on the Injury Journal Data Entry Form and matches
it to the Employee Number in the Employee Master Staff Table and pulls in the
Supervisor and Department associated to that employee, then Auto populates
the Supervisor and Department textboxes on the Injury Tracking Form - but
it's not working.

Private Sub Employee_Number_AfterUpdate()
Me.txtDepartment = Me.Employee_Number.Column(4)
Me.txtSupervisor = Me.Employee_Number.Column(5)

End Sub

 

[kingston via AccessMonster.com]

What exactly isn't working? Remember that the first column is Column(0).