Disabling Option Group buttons in response to content of a field 1

[Locoman]

Hi folks,
I did look under FAQs, honest, but could not see anything quite like my question:

I have a form with an option group of five buttons which select different reports for various records depending on which option button is selected - so far so good.

I now want to grey out certain buttons when the choice is not relevant for the new record selected. I have tried code like:

If Me!data = "xx" Then
Me!Option3.Enabled = False
etc,..etc...
Else
Me!Option3.Enabled = True
etc,...etc...
End If

This works, but does not automatically "update" the option button group, i.e. the selected disabled button(s) will appear correctly greyed out but only when you click on another button in the group.

Is there a way to make the option button group choices automatically track as the user selects different records on the main form?

 

[Beeps]

Hi,


Did you put the code above in the AfterUpdate of your text box?

 

[Locoman]

Hi Beeps,

No, I had not put the code there - but i have just tried that and it did not work at all. The only way it seems to work is in its own private sub as Frame(nn)_BeforeUpdate.

Regards,

Brian

 

[Beeps]

Is your option group and your text box/recordset on the same form?(i.e. is there a subform involved?)

 

[Locoman]

Yes, the option group is on the main form with the text box. So I didn't screw up my work so far, I built a simple test form in a blank db, displaying the only field from a simple table, plus the option group. This test form behaves exactly the same as the full "real" form, as described previously.
Hope that helps!

 

[KenReay]

Hi

Your message implies that the form is bound and that you wish to enable/disable buttons depending on the content of a column in the bound record, right?

If yes, put your enable/disable code in the oncurrent event of the form Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Locoman]

Thanks Ken!