Hello,

I am somewhat new to Access and am having difficulty figuring out how to change a previous entry automatically when a new entry is created.

My form contains tool#, datecalibrated, duedate, and complete fields. The way it is set up currently is I can query (monthly) the tool and due date in mm/yyyy format. My problem is trying to display past due or "incomplete " calibrations as well as the current ones....