Access 2000 - Populating Text Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form I made with Form Wizard. The three main fields are User ID,
Name and Surname. These are text boxes on the form.

What I want to do be able to do, is when your type the User ID into the User
ID text box and tab out, I would like it to fill in the Name and Surname
boxes automatically. I have seen this done before, but don't know how to do
it.

Many Thanks
 
Another approach would be to use a combo box to list users (UserID,
FirstName, Surname), and code in the combo box's AfterUpdate event to set
the values in the two name-related fields.

By the way, Access treats "Name" as a reserved word -- if you don't change
the title of that control, both Access and you could end up confused about
what's being referred to...
 
Back
Top