display multiple fields combo box

[statty01]

Hi,
I have created a combo box, that when I hit the drop down arrow 3 fields appear - name, dob, time.
But when I choose my option, only the first field is displayed whereas I would like to display all three fields. I have tried everything.


Any suggestions?

[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.

[statty01]

Thank you for your reply,
That is much clearer now!

[jzwp11]

You're welcome. Glad to help.

[Parotina]

I've been messing with this for days!

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.

[jzwp11]

I'm glad my earlier post helped you out. Let us know if you have other questions.