The OpenForm action was canceled (1 Viewer)

[gblack]

I have a form that opens when you initially open the MS Access file...

This first form posts session and user ID data to a sessions table, then closes itself and opens an end user form (i.e. the main form in the application)

It's work just fine for many weeks, up until a few minutes ago. Now, when I open the MS Access file I get this error message:

Run-time error '2501':

The OpenForm action was canceled.


When I choose "debug" from the error message, it's showing me that the error happens here:

Public Sub CloseMeAndOpenMain(frmMe As Form)
    DoCmd.Close acForm, frmMe.Name
    DoCmd.OpenForm "0100_0000_STRAT_AND_REQ_ASSEMBLY_ECs_LISTING"
End Sub

The thing is, I can then walk through the code with no issues (i.e. when I hit F8, it runs...)

Also when I open the first "sessions" form from inside MS Access (as opposed the file open feature) it runs just fine and opens the main end user file without any issue.

I only get the error when I initially open the first form from the file...

Anyone have any ideas as to why I am getting this error message, as such?

Regards,
Gary

 

[gblack]

So after I posted this... I tried the stupid thing again and it worked without any issues... Previously I had run this dang thing like 10 times in a row (easily) and it didn't work... I did nothing to change anything and it opened just fine...

Apparently just writing to the boards, fixed the problem... just like Magic... but real.