Refering option button name

[le888]

Hi,

How can I refering the name of the button function instead of the control value? I have created a independant field which the control source is :

=[OptionFilter]

This gives me the control value of the option button. What I want is the name of the button, example "Option1".

Any ideas?
Thanks,


Le

 

[KenHigg]

I assume you want the name of the active control on the screen?

 

[le888]

I assume you want the name of the active control on the screen?

Yes, when I click on option1 which the name of the option1 is company1 and I want it appear on my independant field "Company1".

Thanks for your reply,

Le

 

[KenHigg]

Private Sub Frame_one_AfterUpdate()

Select Case Me!frame_one
Case 1
Me!Text0 = "One"
Case 2
Me!Text0 = "Two"
Case 3
Me!Text0 = "Three"
End Select

End Sub


????

 

[le888]

Thanks very much, what a great help!!

Le