RecordChangeComplete

[Peter Mitchison]

Hi,

I have an adp application connected to a SQL Server database. I need to run
some code after a record is deleted from a form. I understand that the
form's AfterDelConfirm happens before the deletion actually occurs so cannot
be used.

So I set up an ADO recordset declared withevents and set to rs=
me.recordset. The code I need to run goes in the RecordChangeComplete event
where I can test whether the change was a deletion or whatever.

The problem is that the event only fires the first time a change is made to
the recordset. The Microsoft site says that the event will either fire once
or on all changes but helpfully it does not say under what conditions each
occurs.

Has anybody any ideas?

Regards

Peter Mitchison

 

[Sylvain Lafontaine]

Maybe a delete trigger on the SQL-Server side will do the job?

S. L.

 

[Peter Mitchison]

Sylvian,

It would except that the adp form won't update from the SQL Server database
as it uses a static cursor. To show my changes immediately I have update the
form text boxes.

Regards

Peter