Why am I getting and error

[Ayo]

I get a OpenForm action was canceled when I try to open a form with this code:

DoCmd.OpenForm "frmSiteConfiguration_Input", acNormal, OpenArgs:="GSM850"

 

[boblarson]

You missed some arguments there;

DoCmd.OpenForm "FormNameHere", acNormal, , , , , OpenArgs:="GSM850"

--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Ayo]

No, not really, because I used the same format for another form and it works
fine.

 

[boblarson]

Well, I'm just giving you the syntax as shown in the help file, the
intellisense and how I've done it. I don't know how it works for your other
form, but I think you'll find that it works just fine if you use what I
suggested.
--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Ayo]

I get a "The OpenForn action was canceled" error when I use: DoCmd.OpenForm
"frmSiteConfiguration_Input", acNormal, , , acFormEdit, acWindowNormal ,
Me.txtSiteID
and I have an Open event in the other form. But when I remove the Open event
from the other form and I use:
DoCmd.OpenForm "frmSiteConfiguration_Input"
The form opens, but to the first record in the table instead of the last
record.

 

[boblarson]

I just realized something. What code do you have in the On Open event of the
form you are trying to open?
--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________