Automatically populate expiration date

[Tyler]

I have a form with a date of when training was completed. I would like to set it up so it displays the date of expiration which is one year from when the training was complete. please help by by telling me where the "code" would go and what the best way of doing this is. Thank you

[rpeare]

in the ON EXIT event of your training completed date (let's call the field TR_Complete) run something like (assuming the expiration is a field named TR_Expires)

TR_Expires = Dateadd("y", 1, [TR_Complete])

I would also add that this is a calculated value and you really do not need to store calculated values on a table. If you are, for instance, running a report about who is going to be due for training in the next month you can run a query based on their most recent training complete date to do that without needing to store the extra piece of data.

[Tyler]

Thank you for your help