Wierd error 1

[snipesnab]

I am trying to open a form by pushing a command button on another form but am getting the error message: "You cancelled the previous operation". I know the code is right but i can't see why it is giving me this error. Can anyone help?

the code i have used is:

docmd.openform "frm instructions" , acnormal

 

[JeremyNYC]

Show us the rest of the code... =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[snipesnab]

Thats the only code assosiated with that command button...

 

[JeremyNYC]

Hmm. Any code in the open or load event of the form? =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[snipesnab]

This is the code that runs when the form opens:

Private Sub Form_Open(Cancel As Integer)
On Error GoTo err_Form_Open

DoCmd.SetWarnings False
DoCmd.OpenQuery "qry del blank fields", acViewNormal
DoCmd.SetWarnings True

Me.Refresh


DoCmd.GoToRecord , , acNewRec


'Me.txtdatelogged.Value = Now()
Me.TxtPhonenumber.Visible = False
Me.lblphone.Visible = False



exit_Form_Open:
Exit Sub

err_Form_Open:
MsgBox Err.Description
Resume exit_Form_Open

End Sub

 

[JeremyNYC]

Step through the code. Where do you get the error?

=============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[snipesnab]

I get the error in the when I try to open the form by pushing a button with the code that only opens a form:

docmd.openform "formname",acnormal

thats the only code behind the button.

 

[jebry]

Hi!

You get this error message when you stop the form from opening either programmatically or manually. This often occurrs when a programmer checks to be sure that there are records in the recordset of the form and then closes the form if there isn't. Assuming the second form is opening the way you want it to, including automatically closing when it should, then trap for the error in the code behind your button like this:

OnError Go To Err_Handler

docmd.openform "formname",acnormal

Err_Handler
If Err.Number = 2701 (I think this is the right number, but just let the error happen and get the number there) Then
Resume Next
Else
Call MsgBox(Err.Number & ": " & Err.Description)
End If

This will exit the Sub when the error is the one you are getting and still allow other errors to be displayed to the user.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[snipesnab]

Tried the code you supplied but still brings up the error. I checked the error no : 2001 and put that in the first part of the error handler but still no luck.. is there another way I can get the form to open when someone needs to see it. The form contains instructions and help text.

 

[jebry]

Hi!

If it isn't sensitive in nature, you can zip and send me the db to look at. It sounds like something odd is going on here and we may be picking on the wrong operation as being cancelled.

hth
Jeff Bridgham
bridgham@purdue.edu