B
benny
I need some help with building a macro.
On a form, how do you use the Set Value Macro to hide (visible=no) a control
based on the value in another field? What would you use for the Item and
Expression?
For example, "Abbreviations" is a yes or no question. Field "U" should not
be visible unless the answer to "Abbreviations" is yes.
Here's what I have and I get a type mismatch error.
Item: [Forms]![Chart Review]!.[Visible]
Expression: Yes
Condition: [Forms]![Chart Review]![Abbreviations]="Yes"
On a form, how do you use the Set Value Macro to hide (visible=no) a control
based on the value in another field? What would you use for the Item and
Expression?
For example, "Abbreviations" is a yes or no question. Field "U" should not
be visible unless the answer to "Abbreviations" is yes.
Here's what I have and I get a type mismatch error.
Item: [Forms]![Chart Review]!.[Visible]
Expression: Yes
Condition: [Forms]![Chart Review]![Abbreviations]="Yes"