
Originally Posted by
jzwp11
You have 2 options. The first option is to concatenate the three fields into one by using a query and then base the combo box on the query. The SQL text of the query would look like this. This will display the name followed by a space then the date of birth and then another space followed by the time
SELECT [name] & " " & dob & " " & [time]
FROM yourtablenamehere
BTW, name and time are reserved words in Access, so it would best not to use them as table or field names.
Your second option is to leave your combo box as is and add two additional textbox controls to your form to display the information from the two additonal fields.
When you add the textbox, set its control source property to the specific column of the combo box
=YourComboBoxName.column(x)
x= the number of the column of your combo box's row source; note that Access starts the counting a zero not 1.
So if the combo's row source looks like this:
SELECT ID, name, dob, time...
and you want to display the dob in a textbox, the column number for dob would be 2.