unselecting an option button

  • Thread starter Thread starter Basil
  • Start date Start date
B

Basil

Hi,

I have a form with a group of option buttons in a frame.
Each button results in a different action.

On one of the buttons it gives a yes/no message box
saying, "do you want to continue blah blah..".

If they select no in the message box, I want the form to
revert to however it was before the option button was
pressed - as if it hadn't been pressed at all.

How can I do this? Currently the option button remains
selected no matter what I seem to do in the code
(cancelevent etc).

Many thanks,

Basil
 
If the option button is in an option group, set the Value of the group to
Null, e.g.:
Me.[Frame0] = Null
 
Hi Allen,

Thanks - spot on. When you first open a form, the options
in an option group are greyed out - do you know how I can
make them greyed out again after the group has already
been clicked?

You have answered a number of my queries in the past... I
really appreciate all the help that you have given (and
it's worked every time!).

Basil
-----Original Message-----
If the option button is in an option group, set the Value of the group to
Null, e.g.:
Me.[Frame0] = Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a form with a group of option buttons in a frame.
Each button results in a different action.

On one of the buttons it gives a yes/no message box
saying, "do you want to continue blah blah..".

If they select no in the message box, I want the form to
revert to however it was before the option button was
pressed - as if it hadn't been pressed at all.

How can I do this? Currently the option button remains
selected no matter what I seem to do in the code
(cancelevent etc).

Many thanks,

Basil
Click to expand...


.
Click to expand...
 
Place a command button beside the group. In it's Click event procedure:
Me.[Frame0] = Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Basil said:
Hi Allen,

Thanks - spot on. When you first open a form, the options
in an option group are greyed out - do you know how I can
make them greyed out again after the group has already
been clicked?

You have answered a number of my queries in the past... I
really appreciate all the help that you have given (and
it's worked every time!).

Basil
-----Original Message-----
If the option button is in an option group, set the Value of the group to
Null, e.g.:
Me.[Frame0] = Null

--
I have a form with a group of option buttons in a frame.
Each button results in a different action.

On one of the buttons it gives a yes/no message box
saying, "do you want to continue blah blah..".

If they select no in the message box, I want the form to
revert to however it was before the option button was
pressed - as if it hadn't been pressed at all.

How can I do this? Currently the option button remains
selected no matter what I seem to do in the code
(cancelevent etc).

Many thanks,

Basil
Click to expand...


.
Click to expand...
Click to expand...
 
aah... null eh! Perfect.

Enjoy the summer... it's windy and raining in London!
-----Original Message-----
Place a command button beside the group. In it's Click event procedure:
Me.[Frame0] = Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi Allen,

Thanks - spot on. When you first open a form, the options
in an option group are greyed out - do you know how I can
make them greyed out again after the group has already
been clicked?

You have answered a number of my queries in the past... I
really appreciate all the help that you have given (and
it's worked every time!).

Basil
-----Original Message-----
If the option button is in an option group, set the
Click to expand...
Value
of the group to
Null, e.g.:
Me.[Frame0] = Null

--

I have a form with a group of option buttons in a frame.
Each button results in a different action.

On one of the buttons it gives a yes/no message box
saying, "do you want to continue blah blah..".

If they select no in the message box, I want the form to
revert to however it was before the option button was
pressed - as if it hadn't been pressed at all.

How can I do this? Currently the option button remains
selected no matter what I seem to do in the code
(cancelevent etc).

Many thanks,

Basil


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top