Un-wanted opening of VBA Editor

[Guest]

I know little about Access…
A user asked me if there is something that can be done to stop the Editor
from opening when running any of the reports in an Access project. All
reports run perfectly but the user is having to hit the F5 key once the
editor is open and stopped on the following line of code:

If Not IsNull(Forms!frmReportOptions!cboClubName) Then
strClubName = Replace(Forms!frmReportOptions!cboClubName, "'", "''")
End If

Whether Forms!frmReportOptions!cboClubName is Null or not the code runs with
a breakpoint that has not been set in place and continues on perfectly when
stepping through or letting run.

Comments most welcome…

Sincerely,
Arturo

 

[Guest]

It is possible that someone compiled the database while a breakpoint was set.
Be sure all breakpoints have been cleared and recompile. Don't know if this
will do it, but it is worth a shot.

 

[Alex Dybenko]

Also try to decompile:
http://www.mvps.org/access/bugs/bugs0008.htm