VBA Question

[LostAngel]

any variables that I want to be available to ALL forms, I usually put in a module

Public strData As String

Now, I can do the following in frmMain

Private Sub cmdInput_Click()
    strData = "w00t"
    frmTwo.Show
End Sub

and for frmTwo's Form_Load:

Private Sub Form_Load()
   Me.Caption = strData
End Sub

Now, frmTwo's Caption would be equal to a variable that you set in frmMain.