Tick Box When Button Is Click

[jamer03]

Hello,

Does anybody know if, when a button is clicked on a form, you can make it tick a tick box inside the same form but in a sub form?

If you have any ideas it will be much appreciated.

Thanks,
Jamer

 

[wazz]

Me.sfrmName.Form!chkboxName = True

 

[jamer03]

Thanks for the reply but where abouts do i put this?

Jamer.

 

[rainman89]

this has saved my butt many times

http://www.mvps.org/access/forms/frm0031.htm

 

[wazz]

- put the form in design view.
- select the button.
- view/properties.
- go to event tab.
- in the On Click event, select [Event Procedure]
- click the small box to the right (...)
- you should be in a code module for the form, and specifically in the On Click event procedure for the button.
- put the code where the cursor is (hopefully you haven't moved it).
- rename the items in red to match the names of your controls:
Me.sfrmName.Form!chkboxName = True

 

[jamer03]

I did what you said but it says it cannot find the object "Me." :S Any idea?

 

[jamer03]

OK its sorted now, but as well as this event happening I want a macro to run on this button at the same time, is this possible?

Jamer

 

[wazz]

add:
DoCmd.RunMacro "macroName"