Unwanted Forms Code break

W

wallymeister

This has never happened to me before and I'm at a loss as to what's going on.

The code behind switchboard (created by switchboard manager) is pausing the
first time I click any button when the file runs.

The 1st time I click a button on the switchboard, Visual Basic window opens
and the "Select Case rs![Command] is highlighted as if I put a break there
(Red Highlight) but there isn't a break there, at least I can't see that it's
there. If I press (F5) continue it's fine and doesn't do it again until I
close Access and reopen this file and press any button the switchboard. If
there is something I've done, I don't know how to undo it.

Any help on this is greatly appreciated.
wallymeister
 
M

Maurice

When this happens code into the VBA editor, press the save icoon and
decompile the database from the debug icon in VBA. Then compress the database
and open it again.

hth
 
W

wallymeister

Hey Maurice,
I did something like you suggested and it fixed it.

What I did was, instead of pressing F5 to continue I pressed Stop(Reset) and
when I did it ask me if I wanted to save changes and I said yes and whala, it
doesn't do it anymore.

Thanks for your quick response.
wallymeister

Maurice said:
When this happens code into the VBA editor, press the save icoon and
decompile the database from the debug icon in VBA. Then compress the database
and open it again.

hth
--
Maurice Ausum


wallymeister said:
This has never happened to me before and I'm at a loss as to what's going on.

The code behind switchboard (created by switchboard manager) is pausing the
first time I click any button when the file runs.

The 1st time I click a button on the switchboard, Visual Basic window opens
and the "Select Case rs![Command] is highlighted as if I put a break there
(Red Highlight) but there isn't a break there, at least I can't see that it's
there. If I press (F5) continue it's fine and doesn't do it again until I
close Access and reopen this file and press any button the switchboard. If
there is something I've done, I don't know how to undo it.

Any help on this is greatly appreciated.
wallymeister
 

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

Top