|
||||||
|
Relational Combo By Richard Rost 3 years ago Combo Box that Gets Values from Another Table 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? MembersMembers 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.
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
Recommended Course
Keywordsmicrosoft 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
|
||||||||||||||||||||||||||||||||||||||||||||
| |||
Keywords: TechHelp Access 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 bas PermaLink Relational Combo in Microsoft Access |