I would like create a multi-column combo box in a form that looks up Social Security Number and the associated first and last name. I want the SSN to show up in the SSN field of the form, and then I want to keep this field information as part of the new record. I also want the first and last name to be displayed in the form, but I do not need to save this information as part of the new record. the form has the following records:

SSN
First Name
Last Name
Leave Type
Leave Date
Leave Amount.

The underlying record has all of the above fieds, except the First Name and Last Name.

How do I create the objects on the form that will display the First Name and Last Name with the associated SSN.

Thanks,

DJ's Daddy

Create one or two UNbound textboxes. If you create two, then on the combobox's AfterUpdate event you put this (assuming the 1st column is SSN, the 2nd is first name, and the third is last name):

Me.txtFirstName = Me.cboSSN.Column(1)
Me.txtLastName = Me.cboSSN.Column(2)

Or if you have just one textbox with the full name:

Me.txtFullName = Me.cboSSN.Column(1) & " " & Me.cboSSN.Column(2)

Note I'm using fake names for things and also note that the first column is Column(0).

Also put the above code in the form's On Current event.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division