Hi,
I am trying to reference a field on a subform from another form. So basically I have FormA - SubformA - FieldA(CheckBox) and then I have FormB - Field B.
When I click a button on FormB, I want to check to see if FieldA is checked or not. Then, depending if it is checked or not, certain data if populated into FieldB.
I've tried:
If Forms!FormA!SubformA.FieldA = -1 Then ....
If Forms!FormA!SubformA.Form.FieldA = -1 Then ....
and a few other varients. Can someone please show me the correct syntaxs.
Thanks,
Jeff
I am trying to reference a field on a subform from another form. So basically I have FormA - SubformA - FieldA(CheckBox) and then I have FormB - Field B.
When I click a button on FormB, I want to check to see if FieldA is checked or not. Then, depending if it is checked or not, certain data if populated into FieldB.
I've tried:
If Forms!FormA!SubformA.FieldA = -1 Then ....
If Forms!FormA!SubformA.Form.FieldA = -1 Then ....
and a few other varients. Can someone please show me the correct syntaxs.
Thanks,
Jeff