On Click Even Property Error

[rodneyb]

Hi,

I have a form that I have been working on which has various buttons which up until a few minutes ago were working fine. Now when I press any of the buttons I get this message:

"The expression On Click you entered as the event property setting produced the following error:."

But there is no "following error" displayed.

The buttons all have On Click Events that I have created but when I checked the link to each one they all compiled ok and there were no errors that I could see.

Any suggestions?

Thanks.

 

[bjackson]

open your form code module
make sure you have at the top of the module

option Explicit

click compile and see if the code compiles ok

that may give you a place to start

 

[rodneyb]

It's already there and when I compile the class module for the form no errors show.

 

[bjackson]

try creating a new db and importing all the objects,perhaps
the db is corrupt

 

[rodneyb]

I ended up getting frustrated in the end and just went back to a previously saved version of the form before it went corrupt.

I made all the changes as before and everything works fine now.

Is it possible that this error would occur if I don't close a db or recordset after declaring and using them?

Cheers.