Making sure all changes are caught

#1 (**permalink**) 28-Jul-2006, 08:13 AM

Hi

I have a detail subform. I need to track any change to a record i.e.
addition, deletion or change so I can update the totals. What events do I
need to trap on the sub form?

Thanks

Regards
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10456-making-sure-all-changes-are-caught.html

*

#2 (**permalink**) 28-Jul-2006, 08:13 AM

"John" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10456
news:ucx2WwogGHA.4712@TK2MSFTNGP05.phx.gbl
> Hi
>
> I have a detail subform. I need to track any change to a record i.e.
> addition, deletion or change so I can update the totals. What events
> do I need to trap on the sub form?

I'm not convinced that you should need to update any totals -- shouldn't
they all be derived from a query or an aggregate function? But if you
do need to catch all updates, the subform's BeforeUpdate, Delete, and
AfterDelConfirm events are probably what you need. BeforeUpdate will
catch the saving of new records as well as edited ones. The Delete
event will allow you to tabulate data from each individual record that
is deleted, while the AfterDelConfirm event lets you determine whether
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10456
those records were really deleted, or whether the user cancelled the
delete.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)