"OpenForm Cancelled" Error

[RonMcIntire]

All:

Strange things are happening here!

I'm opening a form from a UserCode dialog and, though it didn't happen before, I am now getting the error "OpenForm Action Cancelled". I went back to a previous version and it's doing it there too. I'm using the OpenArgs feature to transfer a UserCode to the program I opening but the same thing happens when I comment out the OpenArgs.

' Open the Edit SVOrders form.
DoCmd.OpenForm "frmEDIT SVOrder (FORM) - 1024x768" ', , , , , , Me.nUsercode

1. Is there a switch in the Access program that can cause this?

2. Is there someplace else I should look?

3. What can cause this error?

Thanks

Ron

 

[RuralGuy]

Try:
DoCmd.OpenForm "[frmEDIT SVOrder (FORM) - 1024x768]" ', , , , , , Me.nUsercode
...and what is that dangling single quote before the first comma?


RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[TheAceMan1]

How are ya RonMcIntire . . .

Not sure if this is the issue, but if the data type of [blue]nUsercode[/blue] is numeric (not text) . . . you'll have to do two conversions to get it across (OpenArgs [purple]only accepts text[/purple]). In the call to open the form:

[blue]DoCmd.OpenForm "frmEDIT SVOrder (FORM) - 1024x768" ', , , , , , CStr(Me.nUsercode)[/blue]

Then in the form something like:

[blue]Me!TextboxName = Val(Me.OpenArgs)[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[RonMcIntire]

All:

Thanks for your response.

As it turns out, I solved my problem by moving the statement to another location in the program. Somehow it was causing a conflict in what it was opening and when.

RG: The dangling single was to comment out the past to see if the I could get the openform cmd to work.

ACE: Actually the Usercode is an 8-character (max) string.

Thanks again for your help.

Ron

 

[RuralGuy]

Excellent! Thanks for posting back with your success.

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit