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
Code:
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