Passing a forms name to a function (without going into the module behind the form)

Using the on-click event handler, I want to pass the current form name to a function using something like this:


This gives me the following error:

"The expression On Click you entered as the event property setting produced the following error: The object doesn't contain the Automation object 'me'"

I can easily do it if I go into the module behind - but for this purpose, I'd prefer not to do that.

Incidentally, the function that I'm trying to call starts as....

Public Function StoreForm(frmName As Form)
Andy BrownDeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
If you want to pass the form NAME try:

To pass the form object itself (As the function you demonstrated expects) try

I'm not 100% sure it works, been a while since I used that notation, but give it a try.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Andy BrownDeveloperAuthor Commented:

The second one worked a treat - thank you Anders.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.