How to make a label appear on form based on option button selection

[alaxmen]

I would like to know how to make a label appear on a form based on a
option buttion selection on a particular record. I want the word
CANCELLED to appear on the form for any records that the user clicks on
an option button. Can someone help me?

Thanks.

 

[John Vinson]

I would like to know how to make a label appear on a form based on a
option buttion selection on a particular record. I want the word
CANCELLED to appear on the form for any records that the user clicks on
an option button. Can someone help me?

Thanks.

Put the button on the form; set its Visible property to No. In the
Form's Current event and in the afterupdate event of this option
button, set its Visible property to Yes appropriately:

Private Sub optLiveCancel_AfterUpdate()
Me!lblCancelled.Visible = (Me!optLiveCancel = 2)
End Sub

replacing 2 with the value corresponding to "Cancelled" of course.

John W. Vinson[MVP]