I'm working with Access XP and wanted to do some debugging on a trivial bit of code. I put a Stop command in the code so that I could step through and trace the changes in variables. The code did not stop just carried on! I tried this a few times, no progress.
Out of curiousity I created a blank database and imported everything. The Stop worked fine, so I renamed the database and set the Startup form, opened it and tried again. Stop did not work. I've done this a couple of times and it seems that if I set up a start from I can't get the Stop command to interrupt code execution.
I'm wondering if it's my copy of Access, when I get home I'll try to duplicate the error. Just wondered if anyone elses has had this?
Running Access 2002 sp-2 im not obtaining the same error,
all my code is a stop call another module then stop again both of these Stop commands work ive tried various options of startup options but still cant get the execution to not stop
thanks Roy, but no. the database is still in the early stages so I haven't set up any startup code yet. I only set the startup form out of habit really.
I'm just putting this one down to the installation of Access. (I've repaired the database imported all its objects into a new database etc etc, and as posted earlier sent it to myself at home where it behaves differently.)