I have created a button to deselect all the option buttons on my form and I have written the following code to automate the button. The code is working in that it’s deselecting all the option buttons. My problem is that the option buttons have an embedded macro that is used to run update queries to select and deselect yes/no records on a table. If I deskect the option manually one by one the selected yes/no field is turned to false in the table. But if I use the button to deskect all the checkboxes, the selected yes/no records in the table corresponding to each option button do not deselect.
The code I am using for the deselect button is
The code I am using for the deselect button is
Code:
Private sub command32_click
Me.optionUSProvYes=False
Me.optionNationalP=false
End sub