Dates in a form

  • Thread starter Thread starter Ellen
  • Start date Start date
E

Ellen

Hello, I have forms made up with and expiration date set
for 3 months after the form is created. Is there a way to
automatically have an email sent to the person who filled
out the form when the date expires? These are active
documents that need to be closed once the date expires
otherwise we are in violation and could be caught in an
audit. Thanks, Ellen
 
This resembles Enron a little, doing an automated electronic shredding :-)
Now about the question. I think there is a misconception people have
about "form" being created. I think you mean "the record was created".
You need to keep the creation date of the record in your data tables.
When the form is opened to access existing data, the form needs to check
the creation date and produce a warning (or delete something, or
whatever) if that date is more than 3 months in the past.
Technically, VBA code behind the form will need to be modified, and
perhaps a small addition to your data structure would be necessary.
Good luck,
Pavel
 
Back
Top