I’m trying to debug some code on a command button and ‘stop’ isn’t forcing a break. Is there some special feature that will prevent ‘stop’ from breaking code execution in certain instances? (my message boxes aren’t stopping the code either)
Each Call statement takes around 30 seconds to run- would that have anything to do with it?
I’m lost.
I have:
(lots of code)
.
.
Call FYMedian(“GPECR”)
Call FYPR(“GPECR”)
MsgBox (“what?”)
Stop
MsgBox (“what?”)
DoCmd.RunSQL “Delete TImmun.* From TImmun”
DoCmd.RunSQL “INSERT INTO TImmun ( ImmunDate, Immun, Country )” & _
.
.
(lots of code)
Of course, I tried it first without the ‘what’ message boxes, which don’t work either.