Access vba code 1

[jay2502]

I have a Form with a Option group that i am using to select which form needs to be opened. I also have an unbound text box that is used for the criteria of the one form.

What I would like to ask is.
Is it possible to make the text box grayed if option one is select and not grayed when option two is select?
And how would I do that?

 

[PHV]

In the Change event procedure of the frame:
Me![textbox name].Enabled = (Me![option group frame].Value <> 1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886