Use Access Form to capture instance wide variable
Posted on 2011-02-10
I would like to create an MS Access 2007 Form, "MainForm", with two form controls to capture user input: "textbox01", and "textbox02".
After the user inputs data into these textboxes, I need the data passed to a Module's Public Function to be used instance wide, even after the form is closed, until the user logs out.
How do you pass the form's control data to be retained as a public variable even after the form has been closed?