Solved Read Data from another form's sub form

Sun_Force

Active member
Local time
Today, 18:40
Joined
Aug 29, 2020
Messages
396
I have 2 forms open on screen. FormA and FormC.
FormA has a subfrom named SubFormB.
FromC has no subform.

When I click a button in FormC, I need to read a date from SubFormB.
How can I achieve this.

I tried:
Code:
Dim Dt As Date
Dt=Forms("FormA").Form.SubFormB.DeliveryDate
But I received Application-defined or object-oriented error.

Any kind of help is appreciated.
 
Forms("FormA").Form.SubFormB!DeliveryDate

It seems I need a ! not . for the control name.
Problem solved.

Thank you
 

Users who are viewing this thread

Back
Top Bottom