Hello - this is really just an informative post. Not sure if anyone else has run into this either:
My main form's load event initializes an object. (Dim myObj as obj, Set myObj = New obj)
This works fine if I manually open the form. However, I have an Autoexec macro which calls a procedure, and that procedure opens the form. I have discovered that any objects I instantiate in load events that are triggered by an autoexec macro actually un-instantiate themselves. Another odd occurence is the VBA IDE will not enter break mode for any code run subsequent to the autoexec macro.
Strange eh? (access 07)
My main form's load event initializes an object. (Dim myObj as obj, Set myObj = New obj)
This works fine if I manually open the form. However, I have an Autoexec macro which calls a procedure, and that procedure opens the form. I have discovered that any objects I instantiate in load events that are triggered by an autoexec macro actually un-instantiate themselves. Another odd occurence is the VBA IDE will not enter break mode for any code run subsequent to the autoexec macro.
Strange eh? (access 07)