Pass data from one form to another form in MS Access (1 Viewer)

Nancythomas

Registered User.
Local time
Yesterday, 21:20
Joined
Apr 20, 2010
Messages
59
I have two forms and I would like to pass data from one form to another form.
Can you please help. Attached is the sample DB
 

Attachments

  • PassDataform1.accdb
    1.2 MB · Views: 338

James Deckert

Continuing to Learn
Local time
Yesterday, 23:20
Joined
Oct 6, 2005
Messages
189
does one form open the other? Or are they just open at the same time.
You can reference another form by forms("formname")!ControlName.property or Forms![formname]!ControlName.property, but if you are opening the other form you can send info to it using the OpenArgs parameter. In the onOpen event of the form check what is in the OpenArgs (e.g. Me.OpenArgs)
https://msdn.microsoft.com/en-us/library/office/ff820845.aspx
 

Users who are viewing this thread

Top Bottom