Historic Entries

[Alan]

Hi,

I'm fairly new to this so any help would be much appreciated. I have a
master table (A2K7) in which summary details are entered (via a form) by
users. What I want to do is save the changes to this field by date in order
that I have a 'history'. I have a 'Date Updated' field (in the master table)
and thought I could use this to update a separate table each time this was
updated. Can anyone point me in the right direction?

Thanks in advance,

 

[Klatuu]

This link will give you all the info you need:

http://www.allenbrowne.com/AppAudit.html

 

[Alan]

Thanks for this Dave. I've done as the article says but it appears to be
falling over on the "BeforeUpdate" property - I am getting a "compile error:
Method or member not found" and it is highlighting .DataID (after NZ(Me)
(Data is the name of my table). Can you help any further? Apologies if it
is a simple fix but, as I say, I am fairly new to this.

Many thanks,

Alan.

 

[John W. Vinson]

Thanks for this Dave. I've done as the article says but it appears to be
falling over on the "BeforeUpdate" property - I am getting a "compile error:
Method or member not found" and it is highlighting .DataID (after NZ(Me)
(Data is the name of my table). Can you help any further? Apologies if it
is a simple fix but, as I say, I am fairly new to this.

What is the name of the primary key field of the table? Is it in fact DataID?
If so, is that field included in the form's recordsource?

 

[Pieter Wijnen]

Shouldn't think anything including the code nz(me) would work...
Me is how a form or report refers to itself (*very* reserved word), so if
you have a field in your db called Me change it ASAP, else you should
probably substitute for a Me.NewRecord type of check

hth

pieter