Thanks for the solution MarkK it was very useful for me to read and useful code to know about.
However in this case I believe there is an easier way!
If a subform is setup on a main form, you simply create a public variable named "mode" in the subform's module. In the main form's form_open...