asked on Calling a function or sub on the subform of a subform from the main form
I have a main form that I want to call a function that is on the subform of a subform. I can't for the life of me figure out the vba syntax to call this function/sub that is on a subform of a subform.
I have my main form
Then on that main form I have a subform.
Then on that subform I have a subform. - This is where the function/sub is that I want to call from the main form.
I have my main form
Then on that main form I have a subform.
Then on that subform I have a subform. - This is where the function/sub is that I want to call from the main form.
Microsoft AccessVBA
Last Comment
crystal (strive4peace) - Microsoft MVP, Access
ASKER
No, it's specific to that subform. It's a function that needs to fire on that subform only. I just need to know the syntax to point to it from the main form.
Well, if you need to call it from "somewhere else", it is no longer "specific".
Even if it is called only once or two, writing a public procedure is not harmfull.
Plus, don't forget that you can give parameters to procedures if needed (even forms).
Even if it is called only once or two, writing a public procedure is not harmfull.
Plus, don't forget that you can give parameters to procedures if needed (even forms).
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Can I remove the delete request and close this question myself? Thank you.
ASKER
Thank you, Crystal! Appreciate your help!!! :)
you're welcome, Larry ~ happy to help
If so, you'd better delagate the code in a public procedure that you'll write in a standard module.