I have check box in a an Access form that updates a table. I want to have this check box automatically checked when a new record is created on another table. The link between the two tables is a VehicleID. Is there anyway I can do this?