Application stopping in VBA Module

[PSULionRP]

I have an Access Application that I am enhancing and when I click on a button
on the form, it is reaching a statement in a VBA Module and is stopping. I
don't have any breakpoints set. Why is it just stopping??? The line is yellow.

Can anyone help me out here???

Thanks in advance for your review and hopeful for a reply.

Thanks!

PSULionRP

 

[Allen Browne]

In the VBA window, choose Compile on the Debug menu.
Fix any errors, and repeat until it compiles okay.
(The Compile item greys out on the Debug menu.)

If that doesn't solve the problem, perform a decompile.
You probably want to follow the recovery steps listed here:
http://allenbrowne.com/recover.html

 

[MikeJohnB]

It might help if you pasted the line of code that is failing?????????????

Regards

 

[Banana]

FWIW-

For cases of "phantom breakpoints" as described by OP, it's usually
sufficient IME to just copy the line where the code stopped/highlighted
the yellow (and to be safe, the above & below lines as well) then delete
those lines and re-insert the code by pasting it back again.

 

[Armen Stein]

It might help if you pasted the line of code that is failing?

Probably doesn't matter in this case, since the line is yellow which
indicates the "phantom breakpoint" problem.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Allen Browne]

Yes, that may solve it.

Once I see any inconsistency between the 2 versions of the code (text and
compiled), I personally want to decompile to deal with whatever other rocks
are hidden under the surface.

 

[Banana]

Yes, that may solve it.

Once I see any inconsistency between the 2 versions of the code (text
and compiled), I personally want to decompile to deal with whatever
other rocks are hidden under the surface.

Aha, I see where you are coming from. I took Michael Kaplan's advice to
not use decompile too often and only as a last resort so for that
reason, I tend to try and fix phantom breakpoint by deleting &
re-inserting the code based on this principle.

Of course when a product reaches a major development, I usually want to
import everything into a fresh blank file, which should usually clear
out the gunk I created throughout my development.