Populating Fields

  • Thread starter Thread starter ApriLee1983
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

populating a field two different ways? 8
Name searching problem 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Incrementing PART NUMBER on form 4
Insert Date into Field2, the first Time Field1 is Populated with Dataon Form 2
How to populate fields in one table from data in another table 1
Populate a Field 3
Populate a value in a form based on another value 1

Back
Top