VBA code window opens when opening a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that opens through a macro, and every time my user tries to
run it, the code window opens up. I've tried opening it manually and through
the macro, and both time it brings up the window. When I try a second time,
it doesn't happen and everything continues like nothing's wrong. It worked
fine two weeks ago. I haven't changed anything.
 
Have you tried recompiling your Access-application?
Open a module and select recompile all.

There used to be a ghost break-point bug.
 
The ghost break point arises. I have found that putting DOEVENTS directly
above the 'error' line will cure it. It appears to have something to do
with timing, that the 'error' line is executed before it should. DOEVENTS
gives it time to complete, and caused no harm on its own.

Easy to try,
UpRider
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top