I have a form with DueDate, CurrentDate and DaysPastDue on it. What I need is a button on the form that when it's clicked on, all the CurrentDate fields in the record are updated to the current date/time. Currently I have this code below on the click event of a button I've labeled as Update Button:

Me.CurrentDate = Now()

Problem here is that it only updates one record (the first one in a column list of records)but does not update the rest. Putting =Now() as the default will only update new records. I've tried on the form open event to put =Now() but once again only one record gets updated. I need it so that all get updated. I have a calculation on the DaysPastDue field that will show me the days the bill is past due. I need to be able to click on this update button each week and get a new updated list of number day's past due. Hope I've given enough information.

---

Reply from Richard Rost:

If you want to change ALL of the values in EVERY record in your table, then you'll need to use an UPDATE QUERY. However, I'm curious as to WHY you need to keep a field for the current date when you can readily grab it on the fly with =NOW() to perform any calculations for days-past-due. You shouldn't need to store it in a field.