Nifty Access - PopUp Forms - Easy!

00:37 press the ok button and the answer is magically passed back into the Text Box on the pop-up Form it was called from
00:55 all the onclick event does is open the Pop-Up form that's it!
01:42 Magic? The form open event loads the class module
02:00 the form is coupled to the class module
02:06 here we have a look at the class initialise event
02:22 the class initialise event triggers the screen active control to grab the control you actually pressed on the Calling Form
02:40 you capture the text box name and keep it in a custom property within the class module
02:50 here is another example
03:05 when they pop out form opens the forms onload event runs and loads an instance of the class module
03:14 the class stores a reference to the active control that's the one you clicked on, on the calling from
03:30 the Blue Box represents the reference (Ref-)
03:40 now you do your calculation within the pop-up form
03:45 press on the ok button and the answer from the out of text box is "magically" passed back to the answer Text Box on the main form!


In this Google Presentation as shown in the video:-
https://docs.google.com/presentation/...