cascade del and update custom msgbox

[Paul Mars]

I need to replace the generic cascade delete warning with a custom user
warning msgbox and I need to create another for cascade update.

Can I just simply catch the generic warning and replace it, or is there more
to this? What about the cascade update.

tx,
Paul

 

[Tim Ferguson]

I need to replace the generic cascade delete warning with a custom user
warning msgbox and I need to create another for cascade update.

I would run a query to count the number of affected records, and then
MsgBox the user with, "You are about to delete 251 records: Okay, Cancel"
and give them the chance to abort.

When it comes to defending your data against the Mad User, you just have to
program around him!

All the best


Tim F