Link to home
Start Free TrialLog in
Avatar of Clive Beaton
Clive BeatonFlag for Australia

asked on

Problem with Stop and Breakpoints

When I run the attached Sub with a breakpoint on i = 1, it displays both messages but doesn't stop on the breakpoint or the Stop statement.

Any clues?

Thanks in advance.
Sub Test()

   Dim i As Integer
   
   MsgBox "Test Message 1"
   i = 1
   Stop
   MsgBox "Test Message 2"
     
End Sub

Open in new window

Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Make sure you have 'Use ACcess Special Keys' selected in the Access options for the Current Database.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"2) Compact the code"
I suspect you meant do a Compact and Repair on the db ...

mx
Avatar of Clive Beaton

ASKER

Thanks for the procedure.  The problem went away after fixing the other question on 'Problem with Command Bars'.

As always, your help, mand then others who contributed, was invaluable.

CRB
You mean the Reference issue ....?

mx
mx,

Yes, sorry.  I think I need a brain transplant.

crb