Relational Combo Boxes in Microsoft Access - Get the Values from Another Table or Query

In this video, I will show you how to pick a customer from a list of customers when filling out service forms. Marie from Chandler, Arizona (a Platinum Member) asks: I have a simple service call form where I enter the customer's name, the service date, and a description of what needs to be done. Is there any way that I can pick the customer from a list instead of having to enter in their info each time I make a service ticket? Silver Members and up get access to an Extended Cut of this video. Members will learn how to create a List Items Edit Form so that you can add to or modify the existing list of customers directly from in the combo box. We will see how to use the VBA On Not In List event to add the user's suggestion directly from code. MEMBERS VIDEO:    • Relational Combo Boxes - MEMBERS ONLY EXTE...   BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: https://599cd.com/RelationalCombo LINKS: Value List Combo Boxes: https://599cd.com/ComboValueList Blank Template: https://599cd.com/Blank Concatenation: https://599cd.com/Concatenation Relationships: https://599cd.com/Relationships Reserved Words: https://599cd.com/ReservedWords COURSES: FREE Access Beginner Level 1: https://599cd.com/Free1 $1 Access Level 2: https://599cd.com/1Dollar FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: https://599cd.com/THFree Blank Template: https://599cd.com/Blank Contact Management: https://599cd.com/Contacts Order Entry & Invoicing: https://599cd.com/Invoicing More Access Templates: https://599cd.com/AccessTemplates ADDITIONAL RESOURCES: Donate to my Tip Jar: https://599cd.com/TipJar Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Consulting Help: https://599cd.com/DevNet Twitter:   / learningaccess   https://en.wikipedia.org/wiki/Microso... https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft... KEYWORDS: microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, combo box, add to combo box, list items edit form, limit to list, on not in list event, notinlist, acDataErrDisplay, acDataErrContinue, acDataErrAdded, NewData, edit drop down list, control source, add entry not in list, drop down list based on another field, drop down list with values from another field QUESTIONS: Please feel free to post your questions or comments below. Thanks.