Hi,
I have an Access 2000 db and I have a form (called "Progress") that displays progress while code from another form is doing a large amount of processing. I update this form by calling some of its Public subs, for example:
[Forms]![Progress].Setup min, max, step
'where Setup is a Public sub, that takes min, max, and step as parameters
So SOMETIMES when my code tries to call the above sub, I get this error:
"Runtime error 91: Object variable or With block variable not set"
But its not always.... usually after I have run the code on the main form at least once... so right now, the only way I continue is to completely close my db and then open it again because it usually works on the first use....
I have absolutely no clue why this is, and I can't seem to find much information...
Thanks so much to anyone who might have any ideas!!!
I have an Access 2000 db and I have a form (called "Progress") that displays progress while code from another form is doing a large amount of processing. I update this form by calling some of its Public subs, for example:
[Forms]![Progress].Setup min, max, step
'where Setup is a Public sub, that takes min, max, and step as parameters
So SOMETIMES when my code tries to call the above sub, I get this error:
"Runtime error 91: Object variable or With block variable not set"
But its not always.... usually after I have run the code on the main form at least once... so right now, the only way I continue is to completely close my db and then open it again because it usually works on the first use....
I have absolutely no clue why this is, and I can't seem to find much information...
Thanks so much to anyone who might have any ideas!!!
