I have some code that was working fine last week. Since then I have installed SQL 7 and Crystal Reports 7 on this machine. I have DAO objects (Database Objects and Querydef Objects) that are created and set at load as global for this module. I later try to reference these objects, and I get Run-time error '91' - Object Variable or With Block variable not set. Odd thing is, this used to work fine, and there is no basis for this message as the Object was created at startup and has not been destroyed since. I found this in several places in my code with no apparent reason for it to fail. I can bring up the Immediate Mode window and execute the function that originally set up the global objects, and then everything is fine ( and it is indeed being called at startup as it should). It's almost as if I am suddenly in a different instance of the User Control (even though I am not). Very strange and frustrating behavior. If anyone has any ideas as to why this may be happening I would love to hear from you at
gman@ubix.com. Even better if you have a solution!
Thanks in advance to all who reply!