Example:
*frm1 has a Public string variable str1 and has a button that launches frm2
*frm2 is 'modal' and 'Pop-up', has a textbox 'txt1' and a button 'btnClose' that closes the form and sets 'str1' to txt1's value
If I launch Form2, enter something in the textbox, then hit the button, and try executing '!Forms!frm1!str1 = txt1' from within the btnClose's subroutine, then MS Access will tell me that it cannot find 'str1'.
I only see 2 courses of action here:
1) create a table to store this value
2) use an invisible form control like a textbox or label in frm1 (because something like 'Forms!frm1!invisibleLabel.caption = txt1' would work 100%)
Both of the solutions are awkward and I'm hoping you can help me come up with something better.