Updating Subform check box from Mainform check box

[Guest]

Hello, I've always found this site extremely helpful for figuring out my
Access problems but this one has me stumped. Forgive me, since I do not know
how to write code.

I have a Mainform called Open PO Main Form that is linked to a subform
called Open PO Sub Form by a field called CustomerPONumber. I would like my
user to be able to check off the box called DELIVERED on the Main Form and
have it automatically check off the box called SUBDELIVERED on the Subform.

Any help that you could offer would be greatly appreciated!

Lemonade

 

[Guest]

Lemonade,
You may want to try setting the control source for the check box in your
subform equal to the check box in your main form.
Go to the properties of the subform check box, right click in the control
source line (under the data tab) and select build. Selelct the Open PO main
form under the folder callled forms. Once you click on the Open PO form, you
will see all controls for the form to the right. Double click on the
appropriate check box. Once you exit out and view your form, it should
hopefully work.

 

[Guest]

Hello Joseph,

Thank you for your good suggestion. It worked but the check only appears in
the subDELIVERED box after the user moves to the next record. How can I make
it so that it will automatically update?

 

[Guest]

Lemonade,

Go to the properties on the main form, click in after update and select code
builder. Once it goes to visual basics, type ME.REFRESH. Save it and it
should automatically update the subform.