Solved TempVars and Form Events (1 Viewer)

[Sarah.M]

you just use the "form's" event to capture the value of [TempVars]![tvarOpenMode]
rather than do it on "separate" macro.

Wow it works! Awesome!!!

Where is the best place to put RemoveTempVar?
Is this a suitable place for it?

 

[arnelgp]

that will do.

 

[The_Doc_Man]

Where is the best place to put RemoveTempVar?

At the point where you know you no longer need it. The trick, of course, is determining that point, which is why I answered in generic rather than specific terms.