How to Pass variable value from one form to another

[jamesnkk]

I have no exactly idea how to pass a variable value from one form to another, How do I do it using, say in Form 1 using DoCmd.OpenForm like the below statement, correct me If I am wrong.

FORM_1
Dim msg As String
strlsql = "Hello"
DoCmd.OpenForm "frmPO", acViewNormal, , msg

Then on the 2nd Form -FORM_2, Should I detect it from the Form_load ? .

FORM_2 (Form_Load)

IF msg = 'bla bla" then
do this ...........................

Endif

[missinglinq]

You use the last argument of the OpenForm command, openargs. strMessage is assigned to openargs in Form1, then retieved in Form2

'On the first form 
Private Sub Goto2ndForm_Click()
Dim strMessage as String    
   strMessage = "bla bla" 
   DoCmd.OpenForm "2ndForm", , , , , , strMessage
End Sub
 
'On the second form
Private Sub Form_Load()
    If OpenArgs = "bla bla" Then
      'Do whatever
    End If
End Sub

[jamesnkk]

You use the last argument of the OpenForm command, openargs. strMessage is assigned to openargs in Form1, then retieved in Form2

'On the first form 
Private Sub Goto2ndForm_Click()
Dim strMessage as String    
   strMessage = "bla bla" 
   DoCmd.OpenForm "2ndForm", , , , , , strMessage
End Sub
 
'On the second form
Private Sub Form_Load()
    If OpenArgs = "bla bla" Then
      'Do whatever
    End If
End Sub

Thanks so much, got your message, it working now.