Date Increase

  • Thread starter Thread starter Dan Wood
  • Start date Start date
D

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?
 
Is there anyway i can set the date password expires field to update
automatically?
Click to expand...

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.
 
Back
Top