option group

[nigelh]

I have an option group set up for status. 3 toggle buttons:- OPen Pending Closed.
If closed is selected an input box requests closers name. If cancel is selected on the input box a message box is issued saying 'incident will remain open'.
My problem: If the incident remains open I want the open toggle to be re-selected. Any ideas would be appreciated.
Cheers

 

[jwindon]

During your code and under the msgbox try

Me.ToggleButtonName = Yes

Etc.

 

[simongallop]

2 ways depending on whether the 3 option buttons are part of an Option Group or whether they are individual.

If they are part of a group then usualy then first button is 1 the next 2 etc. So for your code use me.OptGroupName.Value = 1 (presuming that Open is the first button)

Otherwise if they are individual buttons use:
Me.optClose.Value = False
Me.optOpen.Value = True

This resets the closed button and sets the open button

HTH

 

[nigelh]

Thanks for your advice