Date Increase

[Dan Wood]

I currently have a form for entering current passwords for systems. I have a
field to enter the date the password was last changed, and another field for
the date the password expires, which is every 30 days.

Is there anyway i can set the date password expires field to update
automatically?

 

[John W. Vinson]

Is there anyway i can set the date password expires field to update
automatically?

The expires field should simply *not exist*.

Instead use a calculated field in a query:

Expires: DateAdd("d", 30, [dateset])

or use the same expression in the control source of a textbox.