Array problem when resetting after breakpoint

[Roy]

I declared a global array which is populated on form_load. I set a
breakpoint in the code and run. I click on a control and execution
begins (and the array is accessed). The code hits the breakpoint and I
am in VBA. I hit 'reset' to stop execution. When I return to the form
and click on that control again I get the error message 'subscript out
of range' as if I had never dimesioned the array!

[RoyVidar]

"Roy" <ro*******@gmail.comwrote in message
<11**********************@e3g2000cwe.googlegroups. com>:

I declared a global array which is populated on form_load. I set a
breakpoint in the code and run. I click on a control and execution
begins (and the array is accessed). The code hits the breakpoint and
I am in VBA. I hit 'reset' to stop execution. When I return to the
form and click on that control again I get the error message
'subscript out of range' as if I had never dimesioned the array!

Yes, I think stopping execution by hitting reset, means you reset all
variables too.

Try continue/F5 or some of the "Step" thingies to continue and keep
your globals.

--
Roy-Vidar

[Roy]

Thank you. I'll learn to deal with it until MS decides to straighten
this out in the year 2050.

RoyVidar wrote:

"Roy" <ro*******@gmail.comwrote in message
<11**********************@e3g2000cwe.googlegroups. com>:

I declared a global array which is populated on form_load. I set a
breakpoint in the code and run. I click on a control and execution
begins (and the array is accessed). The code hits the breakpoint and
I am in VBA. I hit 'reset' to stop execution. When I return to the
form and click on that control again I get the error message
'subscript out of range' as if I had never dimesioned the array!

Yes, I think stopping execution by hitting reset, means you reset all
variables too.

Try continue/F5 or some of the "Step" thingies to continue and keep
your globals.

--
Roy-Vidar

[Rick Brandt]

Roy wrote:

Thank you. I'll learn to deal with it until MS decides to straighten
this out in the year 2050.

What is there to fix? Reset means "reset the project". Losing variable values
would be the expected result of that.

If you handle all errors properly then reset never occurs unless you want it to.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Roy]

The icon is a universally accepted STOP, as has appeared as far back as
tape recorder consoles. Yes, I won't argue what "reset" should mean.
But, if all I want to do is halt execution why would I want to reset
the project so that reinvocation of the still-open form bombs out
because my initialization has been undone?
Rick Brandt wrote:

Roy wrote:

Thank you. I'll learn to deal with it until MS decides to straighten
this out in the year 2050.

What is there to fix? Reset means "reset the project". Losing variable values
would be the expected result of that.

If you handle all errors properly then reset never occurs unless you want it to.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com