Combo Box Help

[cmccarroll@verizon.n]

I have combobox displays the users' first names and last names. When I select the drop-down control and after I select another user, it only shows the last name of the user I selected.

tia,
cmc

 

[fugifox]

I have combobox displays the users' first names and last names. When I select the drop-down control and after I select another user, it only shows the last name of the user I selected.

tia,
cmc

Maybe it's because you haven't set the column widths of your combo box?
Access tries to display all the fields in a combobox when the focus is set to it,
but when focus is lost, only the ones that fit are the... lucky ones to be displayed.

Set them to an enough width along with the total width of your combo box.
You can simplier create a new field on your query the combo box is based on,
having the following expression
FullName: LastName & " " & FirstName
(change LastName and FirstName with your relative fields).
By this way you have both firstname and lastname fields in jsut once