Automating checkboxes in previous entries when a new entry is made.

[smp331]

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.

So if a tool is due 11/2008, the complete field will show as False until a new calibration date entry is created, then automatically change to True. Basically, I want the latest entry to remain False until a new date is entered.

Any ideas how to achieve this? Any help for this beginner would be great.

Thanks in advance!

[FishVal]

Hello,

As soon as form fields are not expected to actually reflect data structure I would ask you to post your table(s) metadata. Here is an example of how to post table MetaData :
Table Name=tblStudent

[i]Field; Type; IndexInfo[/i]
StudentID; AutoNumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time

Regards,
Fish.