Disable OK command button until checkbox is selected

[be17]

I would like to make my program have the OK button "disabled" until the user selects one or more checkboxes on the form, at which time it would be enabled. I am new to programming and I don't know what code to use. Any help would be appreciated. Thanks.

 

[WP]

In Form_Load event put

commandbuttonname.enabled=false

then in check box click event put

commandbuttonname.enabled=True

commandbuttonname should be replaced with your command button name.

Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[be17]

Thank you very much. That's what I was kind of thinking, but I thought I would ask first to save time and hassle. It sounds very easy - I hope it works.

 

[be17]

That worked great. However, I also have a "Reset" command button on the same form. When the user clicks the "Reset" button it clears and resets all of the checkboxes so that none of them are checked. I would like it to work so that if the user clicks Reset, it will again disable the OK button until they reselect one or more checkboxes. This is the code I currently have (but the OK button remains Enabled, so something isn't working). Any suggestions??

Private Sub cmdReset_Click()

cmdOK.Enabled = False

chkLeftBlank.Value = False
chkNotFor.Value = False
chkInternal.Value = False
chkShred.Value = False
chkOnline.Value = False

End Sub

 

[SeanGriffin]

When you set the value of a checkbox it runs the checkbox_click sub. in this sub you set the cmdOK.enabled to true so if you set the cmdOK.enabled = false after setting the check boxes this should fix the problem

-Sean