Run | Run Sub/User form not working ?

[sjl]

Hello,

I have hit a wall trying to debug my VBA code. I set a break point, then try to run the code to that Point. However, whenever I click on RUN | Run Sub/User Form, VBA pops up a window called "Macros" and within that window is a prompt for a "Macro Name:". This does not seem to be the expected action. Very frustrating!

Any ideas why I am getting this, or what I am doing wrong greatly appreciated,

SJL

 

[mdlueck]

I see that Macro box when I hit, I believe, F8 one too many times when I am using the debugger to trace through code execution.

So you never see the debugger / stepped code execution at all?

 

[sjl]

mdLueck,
No, I have never had it work as indicated in online instructions.....

I just got out of my VBA window and got back in. Set a breakpoint, and clicked on Run Sub/User Form under the Run menu. It does nothing but throw me the Macro window.

Sarah

 

[sjl]

I did now try the Run | Reset, and Run | Break....and don't get the Macros window thrown up...but it does not run (break point does not get highlighted in yellow, nor can I get any values to pull up when I query for them in the Immediate Window (when in Break mode).

And, if I try to Step Into the code, I get this annoying background "beep"....telling me, I guess, that I can't step in.

I am in a Private Sub Form_Load()... perhaps I can't step-into this type of code ??

thanks,
Sarah

 

[mdlueck]

mdLueck,
Set a breakpoint, and clicked on Run Sub/User Form under the Run menu. It does nothing but throw me the Macro window.

Set a break point, then go to the Access form, put it into "Form View" mode, and use your application the way it is intended. When code execution encounters the break point, the code debugger / stepped execution should begin.

 

[lorenzrg]

I'm having the same issue. It does work by setting the breakpoint and going back and putting the form into view mode, but I didn't have to do that before. It all of a sudden stopped working the other way.