N naobao Registered User. Local time Today, 10:02 Joined Feb 13, 2014 Messages 99 Jul 18, 2019 #1 How can I open another form can copy two field data ? Please check the picture, Thank you so much!! Attachments check.png 59.9 KB · Views: 92
Uncle Gizmo Nifty Access Guy Staff member Local time Today, 18:02 Joined Jul 9, 2003 Messages 17,498 Jul 18, 2019 #2 See Example:- LabelCheck.zip Code:- Code: Private Sub Command0_Click() Dim strFrmName As String strFrmName = "Form2" DoCmd.OpenForm strFrmName With Forms(strFrmName) .txtShipment = "Test Shipment" .txtStaff = "Test Name" .Caption = "I CAN CHANGE THE CAPTION" End With End Sub Attachments LabelCheck_1a.zip LabelCheck_1a.zip 23.4 KB · Views: 82
See Example:- LabelCheck.zip Code:- Code: Private Sub Command0_Click() Dim strFrmName As String strFrmName = "Form2" DoCmd.OpenForm strFrmName With Forms(strFrmName) .txtShipment = "Test Shipment" .txtStaff = "Test Name" .Caption = "I CAN CHANGE THE CAPTION" End With End Sub
N naobao Registered User. Local time Today, 10:02 Joined Feb 13, 2014 Messages 99 Jul 19, 2019 #3 Thank you very much for help!