Displaying multiple fields in combo box

[westoby1989]

Hi there,

I have set up a form with a combo box. The combo box is used to select the customer for an invoice. It is linked to the table of customers using an autonumber. In the drop down list both Surname and Forenames are displayed however once the customer is selected only the forename is displayed.

Can anybody help with displaying both names once a selection has been made.

 

[MajP]

Concatenate the names into a single field

Select customerID, LastName & ", " & FirstName as FullName from someTable

 

[westoby1989]

That's great. Worked a treat, thanks for the advice.