Corrupt VBA

[onechriswhite]

Hi


I added some VBA to a form to requery its data on load (I think)

The form is FRMSelectUnits

Now, every time I try to view ANY code, Access crashes

I have attached a copy

Please help!Assessment DB.zip

[NoellaG]

Hi, hopefully you have a back-up copy of the database dating befor you added the code to your form. In this case you might try to delete the form from your database and import an incorrupted version of the form.

success
Noëlla

[JamesDeckert]

try this one.
I was able to open the VBA and there was a compile error so I commented out the routine
Private Sub Check26_Click()

[onechriswhite]

try this one.
I was able to open the VBA and there was a compile error so I commented out the routine
Private Sub Check26_Click()

Wow that works great, thank you so much!

So, how could I have got to view the code to fix it myself and, once there, how do I find a compile error? I'd love to be able to fix it myself but can understand if it's way beyond me! I can write a few bits of code and SQL clauses etc but nothing beyond that atm.

Also, is it something I did wrong, or just something that Access does from time to time? I thought I had eliminated these kind of corruptions by not using the wizard when adding command buttons, etc.

Thanks again, it's saved me from madness!

Chris

[JamesDeckert]

I didn't do anything special. I opened the VBA Database Tools>Visual Basic on the ribbon.
But I have had trouble with opening Access DB's before if there is a compile error.

to check for compile errors. In VBA editor debug>compile
I assume the routine I commented out will need fixed, just make sure it compiles ok when you are done fixing it.