Macro

[Guest]

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"

 

[Guest]

Much easier to do in VBA
You need to put code in two places. Once in the form's Current event so it
will set the visibility of U for existing records:

If Me.NewRecord Then
Me.U.Visible = False
Else
Me.U.Visible = Not Me.Abbreviations
End If

Then in the After Update event of Abbreviations

Me.U.Visible = Not Me.Abbreviations

 

[Guest]

Yes that was much easier and it works. Thanks!

Much easier to do in VBA
You need to put code in two places. Once in the form's Current event so it
will set the visibility of U for existing records:

If Me.NewRecord Then
Me.U.Visible = False
Else
Me.U.Visible = Not Me.Abbreviations
End If

Then in the After Update event of Abbreviations

Me.U.Visible = Not Me.Abbreviations
--
Dave Hargis, Microsoft Access MVP

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"

 

[Guest]

Glad I could help, benny.

As you progress in your experience with Access, you will find that Macros,
though usefull for some things, have their limitations.
Most professional Access developers don't use Macros because of the
limitations.
You time to learn VBA will be well spent.
These newsgroups are great resource for finding ways to use VBA to solve
your problems.
Best of luck to you.
--
Dave Hargis, Microsoft Access MVP

Yes that was much easier and it works. Thanks!

Much easier to do in VBA
You need to put code in two places. Once in the form's Current event so it
will set the visibility of U for existing records:

If Me.NewRecord Then
Me.U.Visible = False
Else
Me.U.Visible = Not Me.Abbreviations
End If

Then in the After Update event of Abbreviations

Me.U.Visible = Not Me.Abbreviations
--
Dave Hargis, Microsoft Access MVP

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"