Sub-form variables being reset to zero

[Miles R]

Thanks for this. Yes indeed the revised code does make a difference and the original value is retained.
Will have to research this a bit more.


The original syntax is how I normally set values on another form. Maybe it confuses things if it is a subform, and I need to use the Child syntax you provided - was not aware about that.
Not sure what you mean though that it is not the Current Event, as pressing the button does trigger the Current Event on the subform as the MsgBox popup shows.

[Welshgasman]

Yes, but pressing a record navigation button also triggers the current event, and the contents of that variable remained.

[June7]

Issue was not with event used but code syntax.

When referencing from another form a form used as subform, must reference through subform container control name.

[Micron]

Form_Subform
That syntax is valid (see the syntax in the project window) and a built in event can be called if it's public. This worked for me if the current event is public:
Form_Subform.Form_Current

The OP used that syntax to set subform filter property, then applying it caused the current event to run.

[Miles R]

Thanks for all the comments. Yes, it seems that as June7 says, reference to a subform must be made through the subform container control name.
I am wondering if setting the filter property directly rather than through the container is what cases the issue and an untrapped error occurs, which reset the variables, although no error is apparent.

Anyway, I am now using the correct syntax and have moved the variables back to the subform header and everything is working correctly.