Finding the current form programatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help Please! I'm running Access Ver 11

I know that to find the current user, I could use the function CurrentUser.
Now, how do I find the current form?

Thanks in advance.
Roland
 
If you mean the form that contains the code that is running, try:
Me.Name

If you mean the form that currently has focus, try:
Screen.ActiveForm.Name

If you have multiple instances of the same form running, then just knowing
the name is not enough. More info in:
Managing Multiple Instances of a Form
at:
http://members.iinet.net.au/~allenbrowne/ser-35.html
 
Thanks for trying to help Allen, but it did not answer the question. My
codes are in a module which is not attached to a particular form. I'll be
calling functions from the module using the OnCurrent event on th forms.
Me.Name was not recognized in the module. I also tried the
Screen.ActiveForm.Name, but it gave an error message that the form must be
active. Any more suggestions please, to identify the current form, for I
need to set some properties programatically before the form displays.

Roland
 
Pass a form reference to the function.

Declare the function in the standard module like this:
Public Function MyFunc(frm As Form)

You can then pass the form reference to the function by calling it like
this:
Call MyFunc(Me)
 
Roland said:
I also tried
the Screen.ActiveForm.Name, but it gave an error message that the
form must be active.
Click to expand...

That may just be a result of the way you're testing your code. If in
practice the form would actually be active at the time the code runs,
Screen.ActiveForm could still work for you. Or, of course, you could
pass a reference to the form, as Allen suggested in his reply.
 
Thanks for the ideas Allen and Dirk. I set up a global variable in the
module and passed the current form using "Me" from the OnCurrent form event.

Thanks so much for the help.

Roland
 
Back
Top