I would like instructions on how to create an audit trail for record changes
in forms and I was also wondering if there is a way to stop users from
changing records after they have entered and saved them. If there is can you
also only allow them to make changes up to 72 hours from inputing the record
then lock it from being deleted or edited in any way. This is Access 2007
please.

On Thu, 15 Oct 2009 10:25:01 -0700, spacemom2
<(E-Mail Removed)> wrote:

Check out this article:
http://allenbrowne.com/AppAudit.html

-Tom.
Microsoft Access MVP


>I would like instructions on how to create an audit trail for record changes
>in forms and I was also wondering if there is a way to stop users from
>changing records after they have entered and saved them. If there is can you
>also only allow them to make changes up to 72 hours from inputing the record
>then lock it from being deleted or edited in any way. This is Access 2007
>please.