Last Name, First
By Richard Rost 3 years ago
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?
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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Subscribe to Last Name, First
Get notifications when this page is updated