Display LastName, FirstName in Combo Boxes

Do you know how combo boxes will only show ONE field when the box is closed. If you have first name and last name for a customer and you want to see them both in the box when it's closed, you have to know this trick.

Olivia from Newark, New Jersey (a Gold Member) asks: I want to make a combo box to select a customer, but the box will only show first name OR last name when it's closed, not both. How can I see them both together? Also, I've got a bunch of Smiths and even a few John Smiths. How can I tell them apart when selecting?

Members

I'll show you how to add a Company Name to the mix. This way you'll see Company (Last, First) and we'll deal with all of the combinations of missing data.

•  Extended Cut Video - Silver
•  Member Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

String Concatenation: https://599cd.com/Concatenation
Relational Combo Boxes: https://599cd.com/RelationalCombo

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.