Macros

[Guest]

I'm new to Access and 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, Combobox1 is a check box. Field A should not be visible unless
Combobox 1 is checked.

 

[Guest]

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"

 

[Steve Schapel]

Benny,

Like this:

Item: .[Visible]
Expression: Yes
Condition: [Abbreviations]=-1

I would guess that this macro is assigned on the After Update event of
the Abbreviations checkbox, right?

--
Steve Schapel, Microsoft Access MVP

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"

I'm new to Access and 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, Combobox1 is a check box. Field A should not be visible unless
Combobox 1 is checked.