ODBC Errors On Form

[Vijaya]

Front End : Access 2000
Back End : SQL Server Version 7

I Create a Table Currency

And Created Refferencial Integrity for the table Currency
with Other tables

I Created Default Form For Currency Table In Access 2000

I Used The ODBC Error Trapping : Using Knowledge Base
Article - 206175,

On_Form_BeforeUpdate And On_Error Event procedures

When I Add A Duplicate Record - I Am Able to trap the
ODBC Error

When I Delete a Record from the table ( Which has
references in other tables ),

I get ODBC Call Failed, Error No - 547, 3631

Is There any way i can use the form to delete a record and
trap the error

Thank you for your valuable time

Regards
Vijaya

 

[Guest]

Sorry Guys

I found the Answer

There was a mistaken on my code

I did not include the code

Response = acDataErrContinue


Thanks

Viji