Determine an expiration date

[woknick]

I Have a form that allows a user to update a password. Each time a password it is updated the current date is recorded. Each password expires 90 days following an update. On the form I have a "Last Updated textbox" and an "Expires in" textbox. What I would like to happen is that when a password is viewed, the Expires in textbox will display the amount of days left until the password is expired.

Thanks in advance


Nick

 

[ghudson]

Check the Access VBA help files or search here for the DateDiff() function.