VBA Trouble

[Daryl2106]

Hello,

Our DB has been working fine and then all of a sudden I get this (attached). It seems that some VBA got corrupted somehow.

So far two forms have been affected where a selection query will not return any records after the field has been updated and the request has been made (button).



Any thoughts and direction would be greatly appreciated.

Thanks and take care,
Daryl

[ranman256]

I got this once or twice in my life. Occasionally, the db gets corrupted. (ALWAYS make backups)
i would have to import the bad form.
Another time I had to import EVERYTHING. Start a new blank db, then import all forms, modules, queries, etc.
This very rare, but the backup saves the day.

[amrut]

Was this db opened/edited/compiled on another PC ?

[Daryl2106]

Thanks for the replies.

No to the "Was this db opened/edited/compiled on another PC ?" as far as I know. It seems to have happened on my machine. I am the administrator.

So I should try deleting and then import a saved copy of the corrupted form as a first measure?

Thanks,
Daryl