Button help- 2

[thowe]

Hello- I would like to have one of my buttons automatically make a check in a check box. Is that possible? I am a relatively new Access developer and NOT a programmer- although I'll write code if someone knows the code to write and tells me where to put it. Maybe this is an "if, then" statement?

 

[LonnieJohnson]

In the buttons click event put

CheckBoxName = Not CheckBoxName

Good luck B-) ljprodev@yahoo.com
ProDev
MS Access Applications

 

[JoeMiller]

Lonnie:

I like that, never seen "Not" used that way. A star answer if I ever saw one!

Joe Joe Miller
joe.miller@flotech.net

 

[thowe]

This is not working. I have gone in and created a macro that runs the above code that was advised by Lonnie =[available in cc?]=Not [available in cc?] it is not working. I go into the properties of the button and try to type that in directly and it doesn't work. I'm not sure about how to create the macro for this...any help? Just want the check box in [availabe in cc?] to check when I click a button that opens a form.

 

[HiBoo]

Try using code as suggested by LonnieJohnson

Private Sub Command0_Click()

Check1 = Not Check1

End Sub

This code will 'Check' and 'Uncheck' the check box every time you click the command button. If you just want to check the check box then change the code to...

Private Sub Command0_Click()

Check1 = True

End Sub

 

[slaman]

Why are you creating a macro? Simply put what lonnie said in the Click event of the button (Right-click the button, properties, All, On Click, press the icon with the three dots, Code, then type what lonnie said:

CheckBoxName = Not CheckBoxName

simple and easy

 

[thowe]

Thank you HiBoo -- although I wasn't entirely sure where to put the code at first, I figured it out! Thank you, another hurdle overcome!!!!!!

~Tanya