removng temporary variables

[Jen0dorf]

Hi

been having issues opening a form based on a queries based on temporary variable.

the query runs once and then the second time hangs access.

I tried all the usual things and following a post ensured that I added a remove tempvar to the form on close event.

THis didn't solve the issue.

However in a fit of madness I removed the remove tempvar command from the onclose event which was in VBA

TempVars.Remove "varBannsBrideSurname"

and then created a macro to remove the tempvar again attached to the onclose event

To my total surprise this seems to have cured the problem.

Have no idea why but thought I'd share.

Cheers



Ian

[RuralGuy]

Thanks for the tip Ian!

[Jen0dorf]

Thanks for the tip Ian!

Not sure if it's a va;id "tip" could well be that my beginners VBA was wrong but either way been testing it all day and it hasn't messed up once!

cheers

Ian