G
Guest
I have copied the comments below from an earlier post that I thought solved
my problem. Although it worked to show/hide the form, when I click the
"ExhB?" box it sets all subforms for all records the same. I only want the
current record to be impacted by the "ExhB?" box. Thanks for your continued
assistance.
Don,
You can't refer to [Forms]![PropandContractsbf] in your macro argument.
The [PropandContractsbf] form is not open at the time (it is merely
displayed within the subform control on the main form). Just leave off
the Forms stuff. I would try it like this...
Condition: [ExhB?]=Yes
Action: SetValue
Item: [PropandContractsbf].[Visible]
Expression: Yes
Condition: [ExhB?]=No
Action: SetValue
Item: [PropandContractsbf].[Visible]
Expression: Yes
I am pretty sure this will do the trick. If not, you may need to use
the full reference to the sub-sub-form in the Item argument, something
like this...
[Forms]![MainForm]![PropandContract].[Form]![PropandContractsbf].[Visible]
my problem. Although it worked to show/hide the form, when I click the
"ExhB?" box it sets all subforms for all records the same. I only want the
current record to be impacted by the "ExhB?" box. Thanks for your continued
assistance.
Don,
You can't refer to [Forms]![PropandContractsbf] in your macro argument.
The [PropandContractsbf] form is not open at the time (it is merely
displayed within the subform control on the main form). Just leave off
the Forms stuff. I would try it like this...
Condition: [ExhB?]=Yes
Action: SetValue
Item: [PropandContractsbf].[Visible]
Expression: Yes
Condition: [ExhB?]=No
Action: SetValue
Item: [PropandContractsbf].[Visible]
Expression: Yes
I am pretty sure this will do the trick. If not, you may need to use
the full reference to the sub-sub-form in the Item argument, something
like this...
[Forms]![MainForm]![PropandContract].[Form]![PropandContractsbf].[Visible]