Option button question

[breukelen]

I have a form where a question is shown.By clicking one of
5 option buttons an answer is given.After clicking a "next"
button a new question is shown.The last clicked option
button is has still the black dot.I like when clicking on the "next" button no option button has a black dot.How can I do this?
Thanks in advance for your help.

Gunter

 

[jiqjaq]

The frame control around the options buttons contains the value set by the clicked option. Set this control to a value different than any of the buttons (usually 0).

 

[breukelen]

jiqjaq,

Thanks for your reply , but how do I program this in VBA ?

regards ,

Gunter

 

[Darrylles]

Hi,

Look at 'Option Frame' in MS Help, then 'optionvalue'.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[breukelen]

Darrylle and Jiqjaq,

Thanks ; the solution was :

choice.defaultvalue = 0

Choice is the name of the option group.

best regards ,

Gunter