<div>
the code would be better placed in the onclick event of each of the three buttons.
</div>


the code would be better placed in the onclick event of each of the three buttons.

<div>
I Tried and it errored out on me.
</div>


<div>
I get<br />
Compile Error:<br />
Method or data member not found
</div>


I get
Compile Error:
Method or data member not found

<div>
Worked when I dropped the &quot;Me.&quot;
</div>


<div>
Strange. &nbsp;You shouldn't have to drop the Me. If the code is behind a subform button as described. &nbsp; Pete's solution should work regardless.
</div>


Strange.  You shouldn't have to drop the Me. If the code is behind a subform button as described.   Pete's solution should work regardless.

<div>
<div class="content wysiwyg-content">
Hello<br />
I have a Main Form with a Checkbox among other things. &nbsp;The Main Form has a SubForm.<br />
<br />
When the Form Loads I have it test a particular tb on the Main Form<br />
If the particular textbox is not null then the checkbox is checked (Value -1)<br />
If the particular textbox is null or 0 then the checkbox is not checked (Value 0)<br />
<br />
<br />
The SubForm has 3 control buttons. &nbsp;What I am wanting to do is have that Main Form's checkbox set back to value of 0 IF any one of those control boxes gets clicked.<br />
<br />
What Code could I put in the Subform's OnClick Event to accomplish this?<br />
<br />
I put a tb in the footer of the Subform to hold a value that gets set to 0 if any of those buttons gets clicked.<br />
<br />
The Click event code I added in the SubForms Procedures is<br />
&nbsp; &nbsp; Me.tbcbtn1Chg = 0
</div>
</div>


Hello
I have a Main Form with a Checkbox among other things.  The Main Form has a SubForm.

When the Form Loads I have it test a particular tb on the Main Form
If the particular textbox is not null then the checkbox is checked (Value -1)
If the particular textbox is null or 0 then the checkbox is not checked (Value 0)


The SubForm has 3 control buttons.  What I am wanting to do is have that Main Form's checkbox set back to value of 0 IF any one of those control boxes gets clicked.

What Code could I put in the Subform's OnClick Event to accomplish this?

I put a tb in the footer of the Subform to hold a value that gets set to 0 if any of those buttons gets clicked.

The Click event code I added in the SubForms Procedures is
    Me.tbcbtn1Chg = 0

Access Main Form Checkbox Change Value on a Change of SubForm Textbox(es)

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.