Passing Multiple Arguments between Forms

[shylock]

I am trying to pass multiple arguments from one form to another. The code for the first form is as follows:

 
Private Sub txtServerNm_Click()
Dim strSName As StringstrSName = Me.txtServerNm + "|" + Me.txtIPAddr
Debug.Print strSName

    DoCmd.OpenForm "frmLogicalServerAdminSingleRec", , , , , , strSName
End Sub

The code form the receiving form is:

Private Sub Form_Load()
    Dim strVal As String
    Dim inPos As Integer
    Dim ipVal As String
     
    If Len(Me.OpenArgs) > 0 Then
        inPos = InStr(Me.OpenArgs, "|")
        
        If inPos > 0 Then
            strVal = Left$(Me.OpenArgs, inPos - 1)
            ipVal = Mid$(Me.OpenArgs, inPos + 1)
            
            Me.txtServerNm = strVal
            Me.txtIPAddr = ipVal
        End If
    End If
End Sub

DeBug.Print shows the expected arguments are in strSName. strSWName = Albatross|140.106.160.29

The problem is that OpenArgs is Null in the receiving form.

I have used this same code format in other forms and is works fine. Can anyone tell me why it doesn't work in this case?

[ranman256]

you don't need to 'pass' them,
all forms and objects are available using the full path name:

forms!myForm1!txtBox1 = forms!myForm2!cboBox2

[Minty]

Are you sure that code works to set up the string , this isn't legal syntax;

Dim strSName As StringstrSName = Me.txtServerNm + "|" + Me.txtIPAddr

Try

Dim strSName As String

strSName = Me.txtServerNm + "|" + Me.txtIPAddr

Debug.Print strSName

Edit : Or is that just a formatting error ?

[pbaldy]

Is the form being opened already open maybe, even in design view?

Minty, the forum software often does that to me when I post code, so I'm guessing that's the cause.

[shylock]

Thanks, one and all. I don't understand why having the receiving form open in design view would matter, but evidently it does. I closed the receiving form and the next time I ran the first form it successfully passed the parameters to the second form. Thanks again.

[pbaldy]

No problem. OpenArgs are passed when the form is opened by the code. I don't know what happens under the covers, but I'd guess that since the form is already open, even in design view, the arguments are ignored. In a sense, the code isn't opening the form because it's already open, so its arguments aren't applied.