How to copy data from another form (1 Viewer)

N

naobao

Registered User.

Local time

Yesterday, 16:06

Joined

Feb 13, 2014

Messages

76

• 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: 51

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 00:06

Joined

Jul 9, 2003

Messages

16,273

• Jul 18, 2019

• #2

See Example:- LabelCheck.zip

Code:-

Code:Copy to clipboard

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

  23.4 KB · Views: 43

N

naobao

Registered User.

Local time

Yesterday, 16:06

Joined

Feb 13, 2014

Messages

76

• Jul 19, 2019

• #3

Thank you very much for help!