Breakpoint won't clear - Access 2007

[Carol W.]

I had set a VBA breakpoint in the Before Update event of a form while I was debugging the form. I'm now finished debugging but every time I execute the code, the code stops at the previously set breakpoint. I've tried ctrl-shift-F9, using F8 to complete the routine and anything else I could think of but the breakpoint keeps kicking in and the code halts.

What am I missing?

Thanks, in advance.

[HansV]

There are some things you can try:

Edit the code (it doesn't matter what, for example type a space), then compile the code (Debug | Compile <project> in the Visual Basic Editor) and compact the datatabase in Access itself (Office button > Manage > Compact and Repair Database)

or

Delete and retype the line with the phantom breakpoint, then compile and compact as described above.

Post back if this doesn't help.

[Carol W.]

Hans,

Suggestion #1 did the trick.