Form works once VB has been opened and closed.

[Voyage34]

Hi



I have a simple form which has worked consistently. It has now stopped working unless I go into 'Design' and select any button. Open the 'On Click' Event Procedure. I don't change anything at all. I then close VB and change to Form View and it works.

The form continues to work until Access is shut down and restarted. I then need to repeat the process.

Any ideas what is causing this? Access 365.

Thanks

[Bob Fitz]

Does the code compile without errors?
Have you ran a Compact and Repair?

[Voyage34]

The form loads with errors and returns errors when pressing any of the buttons.

I haven't run a Compact and Repair though.

[Voyage34]

Compact and Repair hasn't changed anything.

Interestingly I created a backup of the database first and the form works fine on the backup, just not on the original. Might need to change to the backup in that case but can't see why it happened.

[June7]

Sometimes weirdness is corruption that can't be fixed. Have to rebuild or some other work around, like your backup. Try renaming bad version so can then rename backup and use.

[Micron]

Compact and Repair hasn't changed anything.

That doesn't address whether or not the code compiles. Try that (or report on it if you have?).
Since you have a working backup, I might also try a decompile and then compile on the problem db and see what happens.

[Voyage34]

Thanks for your help everyone. The backup seems to be working fine so will switch to using that.

I am a novice and have been running a very basic database to help with my work. The 'code compile' statement and how to check it is alien to me. Sorry.

[Micron]

The 'code compile' statement and how to check it is alien to me

You're at work but can't use a search engine like Google and look up what you don't know?