show full name in combo box

[NotaryEtc]

Hello,



In my Customer table (named customerT), I have a firstname and lastname field.....how can I show the customers full name in a combo box?

[June7]

Concatenate:

SELECT ID, Lastname & ", " & Firstname AS CustName FROM customerT;

[NotaryEtc]

Thank you but where do I put that at?

[June7]

Combobox RowSource property.

[NotaryEtc]

Great, thanks!

[NotaryEtc]

that didn't work.....I'm now prompted to enter a parameter when opening the form, and when I do that, it tells me that the field size doesn't permit my selection

[rpeare]

You'll have to modify june's SQL statement driving the combo box to include your table's primary key, in June's example he's just using ID to indicate the Primary Key field.

[NotaryEtc]

That did it!! Thanks you all!!

[Synergy.ron@gmail.com]

Hello,

In my Customer table (named customerT), I have a firstname and lastname field.....how can I show the customers full name in a combo box?

watch this...hope it helps..
(149) Display LastName, FirstName Together in your Combo Boxes in Microsoft Access (Full Name) Concatenate - YouTube