VBA Ignoring Stop . .

[Evagrius]

Hello,

I am not sure what I did wrong. I have a stop on my vba code so I can step through it. The code is on the "current event" of a form. When I go to the form and run it, the code seems to work, but it does not stop at any of my break points. I think I may have accidentally changed some setting - but I am not sure which one. Can anyone advice? Thank you!

 

[boblarson]

Go to Access Options > Current Database and find the USE ACCESS SPECIAL KEYS and check the box.

 

[Evagrius]

Ahhhhhh - thank you Bob! I was really starting to panic! I though the db was corrupted!

I suppose I have to read up on what the special keys have to do with VB.

 

[boblarson]

It does a lot - keeps users from using F11 to open the Navigation Pane (or database window from previous versions), won't stop at breakpoints, won't show Immediate Window, and won't show VB window.

But while developing you want to keep it checked. When about to release it then you can go uncheck it.

 

[Evagrius]

This is great information - thank you Bob!!