display whole list of columns that comprise query in combobox

[phineas629]

I created a combobox with the wizard. I have a query as the rowsource for the combobox. After I make a selection then it only displays one of the many columns in my query. It's important for me to display the whole list of columns as it is a person's full name.

Thanks in advance

[pbaldy]

You can either concatenate the fields together in the query and display that column, or use this to display in a separate textbox:

BaldyWeb - Autofill