When I check a checkbox in one table, I would like to have a checkbox in another table automatically checked. The first table, Docs in Progress, has the optional field Library Number and the checkbox Revision. The second table, Library Index has the primary key field Library Number and the checkbox Under Revision. If I enter a Library Number in the first table that matches the number in the second table and I check the Revision checkbox, I would like the Under Revision checkbox automatically checked. And, if I delete the record or just the number in the first table, the Under Revision checkbox should then be automatically cleared.<br>I would like to achieve this without using an update query. Can I do this with a bit of code in the Code Builder in Form design? Can anyone give me a sample of code to use? Thanks.<br>