Display two fields in the Combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Joe C said:
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.
Click to expand...

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.
 
Back
Top