Trouble with OpenForm action was cancelled

[ladybug76]

Hello Again.

I'm so close I can TASTE IT! I'm working in Access 2003. I've read a bunch of posts, but still can't get to the bottom of this.

I have a "Selection Criteria" form (with Two free form Text Boxes Named Line_Num and Claim_Num).

Based on the entry in both fields, the users want to click on a button that launches and filters the returned results of the "Main form" by the Line and Claim numbers from the Selection Form. they want to be able to update data on the Main form when it launches.

I know the LinkCriteria is returning values (I put in a MsgBox at one point to see if that was the problem.. but it returned both values as part of the LinkCriteria string). I just keep getting "OpenForm action has been cancelled". I can't figure out what I'm doing wrong.

It works when I put the "DoCmd.OpenForm stDocName, , , stLinkCriteria" line in the Immediate window, so I know its something simple, but I just don't program enough to spot it.

The Main form has a recordsource of a query, the query references the Text Box input parameters (Text0 and Text2) from the "Selection Form"

I also tried using the main table (Drug_Util) as the "main form" record source. But got the same error.

ANY and all help is much appreciated.
Thank you so much, in Advance! :)

Private Sub CmdFormAdjustmentsForm_Click()
On Error GoTo Err_CmdFormAdjustmentsForm_Click
 
    Dim stDocName As String
    Dim stLinkCriteria As String
 
    stDocName = "F_ADJ"
    stLinkCriteria = "[Line_Num]='" & Me![Text0] & "' AND [Claim_Num]='" & Me![Text2] & "'"
 
 
    DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit
    DoCmd.Close F_AdjSelect
 
 

[Stewart Ross]

DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit
DoCmd.Close F_AdjSelect
 

Hello again Ladybug76.
As it stands, it seems that the current DoCmd.Close is closing the form you have just opened. You appear to be missing an optional parameter in the DoCmd - the object type. I do not know what F_AdjSelect is - if it is meant to be the name of the current form it should have been placed in double quotes to treat it as a string literal.

If you want to close the current form you can refer to the form name using the Me.Name property of the form itself. If it is not the current form, supply the name of the actual form as a string literal or string variable. Both of these are shown below.

DoCmd.Close acForm, Me.Name
DoCmd.Close acForm, "substitute the name of the form here"
DoCmd.Close acForm, StrVariableValue

-Stewart

[ladybug76]

Hello Stewart.

Guess you drew the short straw (re: answering one of my posts) :)

F_ADJSelect is the Selection form the user keys their two parameters (Line and Claim number) into, then click the Command Button to launch the F_ADJ form. The F_ADJ form needs to be filtered on the Line and Claim numbers from the prior form. I had put the "Close" command on the F_ADJSelect so their weren't a bunch of forms open.

I tried commenting out the Close command, but I'm still receiving the same "OpenForm action was cancelled".

I did more research and apparently this is a MS Access Bug type thing. Unless you see anything else blatantly incorrect :D

Thanks for your response and help!! I do appreciate it.
~lb

[Stewart Ross]

Guess you drew the short straw (re: answering one of my posts) :)

No, it's always a pleasure to assist you Ladybug!

...The F_ADJ form needs to be filtered on the Line and Claim numbers from the prior form.

Are these values actual numbers and not text? If they are, take out the single quotes on either side of the references to them in your strLinkCriteria statement - the single quotes apply to string literals only. The 'if they are numbers' version is shown below.

stLinkCriteria = "[Line_Num]=" & Me![Text0] & " AND [Claim_Num]=" & Me![Text2]

-Stewart