Error: You can't carry out this action at the present time

[DanR]

Hello

I've just started getting the following error, triggered by the command DoCmd.Close on a form in Access2000.

The error description is:
'You can't carry out this action at the present time.'
Error number: 2486

I've never seen this error before, and that piece of code (on a standard Close command button) has been working fine, and not recently changed.

I have been working on code behind other controls on the form, but the connection is not obvious.

Any thoughts on what might be happening?

thanks
Dan

 

[DanR]

Has anyone even seen this error before?

Has anyone even seen this error before? Or knows under what circumstances it is trigered?

thanks
Dan

 

[The_Doc_Man]

Perhaps you have code behind an event that is preliminary to a Close event that sometimes will allow you to cancel the event?

For instance, a Close often implies an automatic update of an underlying record. So there would be a BeforeUpdate event, which can be canceled. If you cancel the BeforeUpdate, you cannot do the Close.

There are other events that can be cancelled and I'm not sure I can tell you off the top of my head what they all are, but an update-related event is my number one guess.