Cannot run any functions from a form

[Maddman]

Just upgraded to 2k3, and I've never seen this problem before. I have
a form with a couple of subforms, and I need a little bit of code to
refresh both of them when the user changes records. However, any time
I run any kind of function off an event, I get a message that says

The expression On Current you entered as the event property setting
produced the following error: A problem occurred while Microsoft Office
Access was communicating with the OLE server or ActiveX Control

I changed the code to do nothing but open a msgbox, and even changed it
from a private sub to a public function. I can run the function just
fine from the VB window, but I get the error whenever I try to run it
off an event. I googled around a bit and looked for any missing
references, but I couldn't find any.

Anyone that could help me out I'd be eternally grateful. This problem
has pretty well brought my project to a screeching halt.

Thanks!

[Wayne Morgan]

If it was a References problem, it shouldn't work from the Immediate Window
either. I would suspect something is corrupted. If you create a new database
file, does it work properly? If so, make a backup of your current file then
try a decompile/compile. If that doesn't work, try creating a new, blank
database file and importing the objects form this file.

Here are some links on handling corrupt files.
http://www.allenbrowne.com/ser-47.html
http://www.granite.ab.ca/access/corruptmdbs.htm

--
Wayne Morgan
MS Access MVP
"Maddman" <ma********@yahoo.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

Just upgraded to 2k3, and I've never seen this problem before. I have
a form with a couple of subforms, and I need a little bit of code to
refresh both of them when the user changes records. However, any time
I run any kind of function off an event, I get a message that says

The expression On Current you entered as the event property setting
produced the following error: A problem occurred while Microsoft Office
Access was communicating with the OLE server or ActiveX Control

I changed the code to do nothing but open a msgbox, and even changed it
from a private sub to a public function. I can run the function just
fine from the VB window, but I get the error whenever I try to run it
off an event. I googled around a bit and looked for any missing
references, but I couldn't find any.

Anyone that could help me out I'd be eternally grateful. This problem
has pretty well brought my project to a screeching halt.

Thanks!

[Maddman]

I happened to have a backup from a couple of meetings ago, and
recreated the subform. Everything works just fine! The DB must have
just gotten corrupted. Thanks!