Option Group Reference (1 Viewer)

[wizcow]

Hello

I have an option gruop on my employee form.
I select what type of employee from the option group.
eg: Practitioner or Therapist

The Practitioners need an Association number, Therapists do not.

I want my form to display the Association text box only when 'Practitioner' is elected in the option group.

The option group result is stored in the table under 'JobType'
The option buttons are named optPrac and optTher

This bit of code does not work....

If Me.optPrac.Value = 1 Then
txtAssociation.visible = true
End If

I get an error 2427 'You entered an expression that has no value'

The optPrac is selected, the optTher is not.

How do I reference this option in my code?

Thanks
Tom

 

[pbaldy]

You test the value of the frame, not the individual choices.

 

[wizcow]

Perfect!

Thanks Paul.

Tom