Command Button

[IanT]

Hi
I have a option group with 6 command buttons. The trouble is when you select a button, the button stays selected, so if you want to select it again you have to select another butoon then go back to it (hope this makes sence!). Is ther a way to re-set the button so it returns to un-selected mode!!!!
Thanks in advance!

 

[ghudson]

You need to set the focus to another object [button, text box] in your code.

Me.AnotherObject.SetFocus

 

[FoFa]

OK, that leads to the question, if it is already selected, why do you need to select it again?

Going on a WAG here, when you change your record, you can reset the code to default by changing the value of your frame by using the (I think) the On Change event.

 

[Mile-O]

Check the Option Value of each toggle within the frame.

Did you place the toggles individually or did you use the frame wizard?

 

[IanT]

I used the frame wizard.

 

[ghudson]

Assuming that each button has a default value incrementing from 1 - 6 and the default value of the "option group" is 0...

Set the default value back to zero at the end of the process.

Me.YourOptionGroupName.Value = 0