Hi, I have a task tracking database. When a task is on hold, say for a week, the fields would be be set up like this... [Assigned_to] To Be Assigned [Status] Hold [Priority] Hold [Due Date] e.g. a week from today When the [Assigned_to] field is "To Be Assigned", I need it to compare the dates so that when the [Due date] = today it will automatically change the fields to [Assigned_To] Linda [Status] Assigned [Priority] URGENT [Due Date] to today Do I need to do a query for this, or can I somehow code the field to perform this comparison and changes? Thank you!!