Nikodemos2
asked on
How to determine the calling Form?
I am using Access 2002 and 3.6 DAO Engine.
OK I am implementing a feedback/suggestion button in each form so new users of this DB can make comments on the data entry forms. How do I capture the name of the calling form? In other words when they press the button in any form, I need to know what form they where on, so I can record that information.
Cheers!
Nikodemos2
OK I am implementing a feedback/suggestion button in each form so new users of this DB can make comments on the data entry forms. How do I capture the name of the calling form? In other words when they press the button in any form, I need to know what form they where on, so I can record that information.
Cheers!
Nikodemos2
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Grassshopper thanks you again Master Jack!
and speaking of variables....
in the declarations of the form
dim OpenedBy as String
In the Form_Open
OpenedBy = me.openargs
this holds the value of the openargs even thru an error event where I've seen OpenArgs get vacated by a code abend.
in the declarations of the form
dim OpenedBy as String
In the Form_Open
OpenedBy = me.openargs
this holds the value of the openargs even thru an error event where I've seen OpenArgs get vacated by a code abend.
A simple way, although probably not the most efficient, is to have a global variable that is populated when the button is pressed. Without knowing how your application is set up, it is hard (for me) to suggest something smoother.
Ken