Access Main Form Checkbox Change Value on a Change of SubForm Textbox(es)
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