Clear checked radio buttons

[sussana17]

hi All,
I have 3 option group with diferents number of radio buttons in each option group. The way that is working my code related group1 to group2 and group 2 to group 3. Let's say in group1 I have countries, group2 'states', and group3 'cities'. When the user click a country in group1 (ie. US) in group2 will populate with the states in US. Then whe the user chooses a state(ie CA), in the group3 will populate with cities within CA.
My problem at the moment is that I have to clear the radio buttons checked. Ie. if want to to choose another country 'France' the radio buttons that I have checked are not clear, they're filled

Any thoughts !!!

Sussana

[VbaNewbee]

hi All,
I have 3 option group with diferents number of radio buttons in each option group. The way that is working my code related group1 to group2 and group 2 to group 3. Let's say in group1 I have countries, group2 'states', and group3 'cities'. When the user click a country in group1 (ie. US) in group2 will populate with the states in US. Then whe the user chooses a state(ie CA), in the group3 will populate with cities within CA.
My problem at the moment is that I have to clear the radio buttons checked. Ie. if want to to choose another country 'France' the radio buttons that I have checked are not clear, they're filled

Any thoughts !!!

Sussana

If you are simply trying to remove the highlighted select radio button, enter this vba after your command statement or once you are ready to select another country .

Create a button on form titled "Clear"

"on click" type ...

Me!groupby1.Val ue = 0
Me!groupby2.Val ue = 0
Me!groupby3.Val ue = 0

[debasisdas]

Try to use the combobox ,instead of radio buttons . that is a better option.