Hi,
Best way to explain this!

I have 3 Forms, frmMain,frmStatus and frmCheckedOut.
After pressing a button on frmMain, frmStatus is shown (vbModal) and a series of code(in a module) is executed. If this code finds that files are checked out then frmCheckedOut is shown (on top of frmStatus, vbModal). This form asks if you want to proceed. Now this is where the problem lies....
If I click yes then instead of carrying on in the next line of code in the module after the form was called, it starts the whole sub again thus resulting in an endless loop of frmCheckedOut popping up. HOWEVER, if I put a breakpoint in at the part where frmCheckedOut is called and step through the code, then once frmCheckedOut has unloaded, the code continues with the NEXT line of code in the module.(which is what I want, only without having a breakpoint in!!!).
I thought maybe I needed a DoEvents somewhere but have tried this with no success .

Has anybody got any suggestions??

Any help will be appreciated

Shaun