Hello everyone.
I created a combo box that displays two fields from a query "FirstName" "LastName" I need for both fields to appear in the combo box once choice is selected so that both FirstName and LastName are updated as one field in designated table.
I was always told to separate names into two fields, but because of duplicate first names I need full name to be displayed on the form during entry. Is this possible with combo box or should it be done in the query and how is it done.
Thanks to all..
Rory
I created a combo box that displays two fields from a query "FirstName" "LastName" I need for both fields to appear in the combo box once choice is selected so that both FirstName and LastName are updated as one field in designated table.
I was always told to separate names into two fields, but because of duplicate first names I need full name to be displayed on the form during entry. Is this possible with combo box or should it be done in the query and how is it done.
Thanks to all..
Rory