Saving prior info for one field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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]
 
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.
 
Back
Top