Creating a "Last Date Modified" for the same date but on different forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wsnyder3@mail.fscwv.edu - 05 Jun 2006 15:48 GMT

I have many forms but all the information is related to one another. I
wanted to know if there was a way that if someone updates a account
that it will show the last date modified on all the forms. I have been
trying to do it by a click but it is not seeming possible. If anyone
has any suggestions I am open.

Thank you

-D

Reply to this Message

Rick Wannall - 05 Jun 2006 16:19 GMT

Many ways to go at this. Here's one:

On any form, put a textbox with controlsource along this line:

=DLookup("DateLastModified", "MyAccountTable", "MyAccountTablePrimaryKey7="
& [txtAccountTablePrimaryKey] )

The assumption here is that on any form where you want to see this date you
have access to the primarykey from the account table, presumably carried as
a foreign key in the related record, or retrievable by walking "up the
chain" of related tables.

Reply to this Message

pietlinden@hotmail.com - 06 Jun 2006 06:19 GMT

> I have many forms but all the information is related to one another. I
> wanted to know if there was a way that if someone updates a account
[quoted text clipped - 5 lines]
>
> -D

Allen Browne has info on this on his website...
http://allenbrowne.com/AppAudit.html

Reply to this Message