Saving prior info for one field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff C - 07 Jan 2005 17:15 GMT

As part of a permanent record I routinely update a "current test date" field
and want to be able to hold the prior dates as part of the record which I
would print on demand and that particular date field would have a list of all
the dates underneath it.

It is not a timestamp or audit trail...

Thank you

Reply to this Message

John Vinson - 07 Jan 2005 22:16 GMT

>As part of a permanent record I routinely update a "current test date" field
>and want to be able to hold the prior dates as part of the record which I
[quoted text clipped - 4 lines]
>
>Thank you

It is exactly and precisely an audit trail: you're maintaining a trail
of all the previous dates. That's the very definition of the term!

To do so you will need a second "history" table, related one to many
to this table. In the AfterUpdate event of the form control (table
datasheets will not work, no usable events) you can run some VBA code
to append to the history table.

John W. Vinson[MVP]

Reply to this Message

Jeff C - 09 Jan 2005 00:33 GMT

Thank you John....could you help me with the VBA Code? I have no idea....I
do know how to get it in though. Even if not..Thank you...I have a place to
start.

> >As part of a permanent record I routinely update a "current test date" field
> >and want to be able to hold the prior dates as part of the record which I
[quoted text clipped - 14 lines]
>
> John W. Vinson[MVP]

Reply to this Message