S Sarah.M Member Local time Today, 22:30 Joined Oct 28, 2021 Messages 335 Mar 17, 2022 #21 arnelgp said: you just use the "form's" event to capture the value of [TempVars]![tvarOpenMode] rather than do it on "separate" macro. Click to expand... Wow it works! Awesome!!! Where is the best place to put RemoveTempVar? Is this a suitable place for it?
arnelgp said: you just use the "form's" event to capture the value of [TempVars]![tvarOpenMode] rather than do it on "separate" macro. Click to expand... Wow it works! Awesome!!! Where is the best place to put RemoveTempVar? Is this a suitable place for it?
arnelgp ..forever waiting... waiting for jellybean! Local time Tomorrow, 03:30 Joined May 7, 2009 Messages 20,349 Mar 17, 2022 #22 that will do.
The_Doc_Man Immoderate Moderator Staff member Local time Today, 14:30 Joined Feb 28, 2001 Messages 30,459 Mar 17, 2022 #23 Sarah.M said: Where is the best place to put RemoveTempVar? Click to expand... 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.
Sarah.M said: Where is the best place to put RemoveTempVar? Click to expand... 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.