troubleshooting Question

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

Avatar of wlwebb
wlwebbFlag for United States of America asked on
Microsoft Access
6 Comments1 Solution563 ViewsLast Modified:
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

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros