Very Computer

Does anyone have any idea how to handle error arising from deleting a
recordset which is a foreign key at another table?
Thank you.

Kris

Trap the error and examine the error message using
On Error Goto and Instr. However this is specific to certain
database and certain data access method.

Other way is check the table where the record becomes foreign key
and notify the user that the record still used at other table