Propagate check boxes through joins

[Christopher]

I have a problem that I can't solve because I am not a good programmer. I have 2 tables a Materials table and a Transaction table, they are joined by a barcode field (1 to many). Both have a check box to indicate that they are empty. I would like to only check the box in the Transaction form and a macro or code to check the corresponding box automatically. What is the best way to go about this?

[TG_W]

Are you talking about updating in a table or form? You start with saying tables, then say you want to check the box in the "Transaction from".

[Christopher]

I fill in forms to input data, but it goes into a table, so that why i mentioned both. I don't know which way works.

[TG_W]

My only suggestion without further detail (I'm kinda lost on how your forms are set up) is to put a button on the form that will close the form when you are done entering data and simultaneously update the check box in the Materials table where barcode= barcode if checkbox is false.