I want the combo box to display 2 columns when selection made

[plshelpme]

is this possible?

when the drop box is dropped you can see two columns; lastname and firstname ...but when a record is selected, the drop box only displays the first column (lastname).

Is there any way around this? Ideal I want the dropbox to display '<lastname>, <firstname>' when a record is selected. Not just '<lastname>'.

any ideas?

 

[Maquis]

A combo box will only display 1 of it's columns after selection. The trick is to set that column equal to more than 1 field.

So instead of having 2 columns for first name and last name, you should have just 1 column with the source [Last Name] & &quot;, &quot; & [First Name] Maq B-)
<insert witty signature here>