How to Open a Popup Form Over the Active Control and Return a Value in Microsoft Access, Part 2

In this Microsoft Access tutorial I will show you how to pass values back from a modal popup form to the original control using TempVars, set up event handling for reusable popup functions, and make it easy to add popups to multiple fields and forms by using a public function for the On Click event. This is part 2. Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will cover how to work with subforms, including detecting if a control is on a subform, figuring out subform coordinates inside the main form, and determining which row you are on. I will show you how to handle pop-up over controls on subforms, which involves more advanced coding than with standard forms. MEMBERS-ONLY EXTENDED CUT VIDEO:    • Popup Over Control 2 EXTENDED CUT MEMBERS ...   BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: Popup Over Control 2: https://599cd.com/PopupOverControl2 PREREQUISITES: Popup Over Control, Part 1: https://599cd.com/PopupOverControl LINKS: Event Handler: https://599cd.com/EventHandlerFunction RECOMMENDED COURSES: Access Developer Courses: https://599cd.com/Developer 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 DIAMOND SPONSORS: More info on our Sponsors: https://599cd.com/DiamondSponsors ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 How to Use Access in 30 Minutes: https://599cd.com/30Minutes $1 Access Level 2: https://599cd.com/1Dollar 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: TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, pop-up over control, modal form value return, tempvars usage, passing values between forms, vba on click event, global module function, public function event handler, control name referencing, forms collection, subform value return, dynamic default button, form object manipulation, extended cut tutorial QUESTIONS: Please feel free to post your questions or comments below. Thanks. Live long, and prosper.