View Full Version : easy entry


kfboren
01-18-2002, 09:33 PM
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
01-19-2002, 08:39 AM
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)