Options Button and focus question

[Guest]

I have 2 option button on my form. Option One is set to display all the data
in the query and Option two let the
user enter a range. I have set the To and From textboxs to Disabled and
Coded the GotFocus on Option two to Enable then textboxs. I would like to
have the textbox set back to disabled when any other option on the form is
selected.
Thanks.

 

[fredg]

I have 2 option button on my form. Option One is set to display all the data
in the query and Option two let the
user enter a range. I have set the To and From textboxs to Disabled and
Coded the GotFocus on Option two to Enable then textboxs. I would like to
have the textbox set back to disabled when any other option on the form is
selected.
Thanks.

The GotFocus is not the best event to use, as the user may select
option1 and the To and From controls are already enabled when you
don't want them enabled unless option2 is selected.

Code the OptionGroup's AfterUpdate event:
[ControlTo].Enabled = [OptionGroupName] = 2
[ControlFrom].Enabled = [OptionGroupName] = 2

Code the Form's Current event:
[ControlTo].Enabled = False
[ControlFrom].Enabled = False

 

[Guest]

Thanks you..

I have 2 option button on my form. Option One is set to display all the data
in the query and Option two let the
user enter a range. I have set the To and From textboxs to Disabled and
Coded the GotFocus on Option two to Enable then textboxs. I would like to
have the textbox set back to disabled when any other option on the form is
selected.
Thanks.

The GotFocus is not the best event to use, as the user may select
option1 and the To and From controls are already enabled when you
don't want them enabled unless option2 is selected.

Code the OptionGroup's AfterUpdate event:
[ControlTo].Enabled = [OptionGroupName] = 2
[ControlFrom].Enabled = [OptionGroupName] = 2

Code the Form's Current event:
[ControlTo].Enabled = False
[ControlFrom].Enabled = False