Populating Fields

A

ApriLee1983

Once I enter an employee ID, I want access to populate the first,last name
fields accordingly so I don't have to type it in every single time.

Example: I have Joe Smith with ID 9999. I want to type 9999 in a field and
have the name populated.
 
A

Arvin Meyer [MVP]

Use a combo box and several textboxes to display the results.

In the AfterUpdate event of the combo box, use some code similar to (air
code):

Sub cboID_AfterUpdate()
Me.txtFName = Me.cboID.Column(1)
Me.txtLName = Me.cboID.Column(2)
End Sub
 
Top