Hide labels

[wiredgecko]

i would like to know how to do the following:

i have a form which has option button A and option button B. i have two labels, A and B. i would like label A to appear if option button A is chosen and label B to remain non-visible and vice versa.

[June7]

I use only VBA code, not macros.

Are these radio buttons in an option group?

Code behind the option group AfterUpdate event like.

Me.labelA.Visible = (Me.optiongroup = 1)
Me.labelB.Visible = (Me.optiongroup = 2)

[burrina]

Also, if they are not in Option Group, then you will need to refer to the control itself. Like June, I was unsure which type and setup you have!

[wiredgecko]

these are just two individual option button. button A is: "showroom sale" and button B is: "home sale". our salesperson picks which type of sale it is

[June7]

You have two fields? If a record can have only one or the other then this should be one field with two choices. Use combobox OR option group control with radio buttons within the option group.

[wiredgecko]

thanks i'll give it a shot

[wiredgecko]

ok I gave it a shot but get an error. my apologies but i am a beginner trying something out of my league. do i actually enter "OptionGroup" or something else

[June7]

Re Option Group, review http://office.microsoft.com/en-us/ac...005188325.aspx