nulad
asked on
Use Access Form to capture instance wide variable
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Even though I used capricorn1's solution before viewing Feddema's. I have to award some points to Feddema because I may use some of her solution in the future.
Thank you both. I greatly appreciate your solutions.