easy entry

[kfboren]

I would like to use a combo box in a form to select a persons last name. I would then like to have access to enter in the same form the persons first name and phone number. What would be the best way to do this???

 

[Jack Cowley]

Create your combo box with ID, LastName, FirstName and PhoneNo. In the After Update event of the combo box use code like this:

Me.LastName = Me.ComboboxName.Column(1)
Me.FirstName = Me.ComboboxName.Colmny(2)
Me.PhoneNo = Me.Comboboxname.Column(3)

Change the names to reflect the actual field names on your form. Remember that the combo box is 0 based so the first column is column(0)