Hello,
I have a form with four unbound text boxes and a button to run Command1037. Since this form is a sub form of a Navigation form I need to pass the following variables into the form I want to open. Can someone tell me how I add all four variables to this line DoCmd.OpenForm "frmOrderStatusDataSheet", acFormDS, , "TxtPlanner =" & Me.TxtPlanner
These are the four variables I need to add to one line
"TxtPlanner =" & Me.TxtPlanner
"TxtPlant =" & Me.TxtPlanner
"TxtRevision =" & Me.TxtPlanner
"TxtOrder =" & Me.TxtPlanner
This is what I have so far
Private Sub Command1037_Click()
DoCmd.Close acForm, "frmOrderStatusDataSheet", acSaveNo
DoCmd.OpenForm "frmOrderStatusDataSheet", acFormDS, , "TxtPlanner =" & Me.TxtPlanner
End Sub