Solved in a form or a subform (1 Viewer)

[Lampje]

Forum,

wants to ask with vba if I am in a form or a subform.
Not the name, but for example 1(form) or 2(subform)

Greeting, L

 

[Uncle Gizmo]

What action triggers the request?

 

[Lampje]

Uncle Gizmo,

With Mouseover I want to call a module, this is a one-time to read the controls in the subform.
When I return, I read the controls of the form again.

Greeting, L

 

[Uncle Gizmo]

I was thinking that I have a function that may be of use to you. However my guess is it won't be much use. I reckon you need to provide more information.

The function I was thinking of is in the code at the bottom of this page. The function name is "fGetParentForm"

CallCalled Class Module - Nifty Access

CallCalled Class Module I will be adding information about my "CallCalled" Class Module here, as it becomes available. The most recent example of it is on Access World Forums here:-VBA to reuse data entry popup form Class Module - Overview Class Module - Overview Video 1 (01:09) You can see how...

www.niftyaccess.com

 

[Pat Hartman]

When you refer to a subform's controls from outside of the subform, do you know for certain what subform record's data you are seeing? Since there is one mainform record and many subform records, this type of request is always suspect.

 

[jdraw]

@Lampje,

More info please. Can you give us some context for this?

read the controls in the subform/read the controls of the form

You may get some insight from this older thread List all controls on all forms

 

[Lampje]

Uncle Gizmo, Pat Hartman, jdraw

Thank you very much for your time and contribution to find a solution to this problem.
My way of thinking went too far, the solution was simpler than my thought.
Now made a Public variable with which a comparison can be made.

Greeting, L