The Close action was canceled. Run Time error '2501' (1 Viewer)

[anandan.cr@gmail.com]

Dear Sir,

In MsAccess 2007 I have two Forms, Form1 and Form2

The code written :-

Dim stDocName As String
Dim stLinkCriteria As String

DoCmd.Close acForm, "Form1"
stDocName = "Form2"
DoCmd.OpenForm stDocName, , , stLinkCriteria


I have also used the following syntax :-
(1) before above code [ Docmd.SetWarning False ] and after Code [Docmd.SetWarning True]
(2) Error Handler


While Closing Form1 and Opening Form2 , I am getting an Error The Close action was canceled.
Run Time error '2501'

Note : In the above mentioned process I do not want to Save Form1 and Form2.

Kindly solve my issue.

 

[arnelgp]

can you open Form2 first before you close Form1?
meaning change the order of your code.

 

[anandan.cr@gmail.com]

can you open Form2 first before you close Form1?
meaning change the order of your code.

As Suggested , I have changed the code , still the same error received.

Syntax as follows :

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form2"
DoCmd.OpenForm stDocName, , , stLinkCriteria

DoCmd.Close acForm, "Form1"

 

[arnelgp]

do you have other codes inside form1 coz i tried it.

 

[anandan.cr@gmail.com]

do you have other codes inside form1 coz i tried

Received your File with thanks , In your attached file it is working.

Pls find my attached File. It is still not working .

 

[Gasman]

Is that because you are trying to close a form in the close event?

 

[arnelgp]

Gasman is correct, you are doubly-closing the form.
see this change on the airline_mast form.