option buttom

[bhelmy]

hi
this my first time to use option buttom but i have one problem

i have 2 option (1 & 2 )

i need when user select 1 system auto unselect 2
and when user select 2 system auto unselect 1

However , i only selected


please

 

[Minty]

Did you use an Option Group ? If you did then the default behaviour is what you have described, so I'm slightly confused.

 

[JHB]

Look at the picture:

 

[bhelmy]

thx
I get it

 

[bhelmy]

sorry but what is the value to true and false to write in VBA code (iF)

 

[Minty]

The option group will return the value of the selected item, you can then use that something like ;

SELECT CASE Me.YourOptionGroup 
     CASE 1              ' Option value 1
              Do something Here
     CASE 2               ' Option 2 
              Do something different here
      etc etc
END SELECT