Track Record Changes

  • Thread starter Thread starter Samer
  • Start date Start date
S

Samer

Hi All

what is the best way to track the changes to record it edit mode, I would
like to see what type of changes the user did in data, I have done the
following:

in the form open even i did

CFN = txtFirst_Name
CLN = txtLast_Name
CADD1 = txt Address1 ......


and in the event before update, I check for data change

if CFN <> txtFirst_Name or CLN <> txtLast_Name or CADD1 <> txtAddress1 then

"Run Append Query " to save the variable in separate table,

but here is the problem

the problem is all the variable return nulll values

I tested when I open the form after the variable, I added
MsgBox CFN
MsgBox CLN
MsgBox CADD1
every thing seen to be ok, just up to this point
I am not sure why it returning null value


Any Idea, or any better way to trach this changes


Best Regards

Samer
 
Hi,

Not sure I can help much, but see if this article by MVP Allen Browne gives
you the steps necessary:

Good luck,
Jeff Conrad
Bend, Oregon
 
Back
Top