Display two fields in the Combo box

[Guest]

Hello all,

Thanks for all of your past help.

I bet I stump you on this one!!!! How do you display two fields in a
combo/list box?
Specifically, I have a combo box that has several fields of data associated
with it. When I am "NOT" clicking one it I need for it to show two fields,
first and last name at the same time.

Thanks again.
JC
PAPI

 

[Joan Wild]

I bet I stump you on this one!!!! How do you display two fields in a
combo/list box?
Specifically, I have a combo box that has several fields of data
associated
with it. When I am "NOT" clicking one it I need for it to show two fields,
first and last name at the same time.

Set the rowsource of the combobox to a query

SELECT [FirstName] & " " & [LastName], SomeID, other fields....
FROM YourTable;

Make the second column bound, and adjust the column widths as necessary.