Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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"
 
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"

benny said:
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.
 
Back
Top