Open a second form using the OpenArgs

[blueraincoat]

Hi All,
I have a command button on a form which will save the data and open a second form, and pass a parameter to the second form.
Below is the code I tried:

Private Sub cmdSaveAndOpenNext_Click()
DoCmd.Close acForm, Me.Name
    DoCmd.OpenForm "frm25-30-43FunctionalCheck-2", , , , , , Me.RepairID
End Sub

On the second form I have code like this:

Private Sub Form_Load()
    If Not IsNull(Me.OpenArgs) Then
    Me.RepairID = Me.OpenArgs
    Else: Me.RepairID = "Unknown"
    End If
    
End Sub

The problem is that when I click the command button and there's a runtime error 2467, sorry for my poor english i'd better not translate the description....
Does anyone know what's wrong?
Thanks in advance.

[RuralGuy]

I would try it without the Else:, just multiline.

 
Private Sub Form_Load() 
  If Not IsNull(Me.OpenArgs) Then
     Me.RepairID = Me.OpenArgs 
  Else
     Me.RepairID = "Unknown"
  End If
 
End Sub

[RuralGuy]

I hope RepairID is a text field/control.

[blueraincoat]

Hi Rural,
I removed the ":", it's the same.
The RepairID is a textbox.
After the runtime error the below line is highlighted

 DoCmd.OpenForm "frm25-30-43FunctionalCheck-2", , , , , , Me.RepairID

Could it be caused by closing the form first before open the second form?

[RuralGuy]

Absolutely! You cannot reference objects on a form *after* you close it. Just place the line of code *after* the OpenForm line. Good catch!

[blueraincoat]

It works now.
I tried that before, but I used the CTRL+X CTRL+V and the code automatically changed back to close first and then open.
This time I typed the code and it works fine now...
A little bit strange.

[RuralGuy]

Excellent! Thanks for posting back with your success.