Error Trapping in Access 2002

Status
Not open for further replies.
C

c2N1YmExMzky

I want to trap for "error 3201 - you cannot add or change a record". This

occurs when a transaction is being added to a table that captures all

transactions for a part master table. The transaction table is linked to the

part master table as a 1 to many relationship with referential integrity.

What event or where should I put the code to trap this error to present other

options to the application user?
 
K

Ken Slovak - [MVP - Outlook]

Post this in an Access group, not an Outlook group.

"scuba1392" <scuba1392@stephengould.com> wrote in message

news:C2B2670D-6F83-4D0B-A240-6CF2B014E81D@microsoft.com...
> I want to trap for "error 3201 - you cannot add or change a record". This
> occurs when a transaction is being added to a table that captures all
> transactions for a part master table. The transaction table is linked to
> the
> part master table as a 1 to many relationship with referential integrity.
> What event or where should I put the code to trap this error to present
> other
> options to the application user?
 
C

c2N1YmExMzky

Thanks I'll move it to MS Office - access - programming.
wrote:


> Post this in an Access group, not an Outlook group.

> >

>

> "scuba1392" <scuba1392@stephengould.com> wrote in message
> news:C2B2670D-6F83-4D0B-A240-6CF2B014E81D@microsoft.com...
> >I want to trap for "error 3201 - you cannot add or change a record". This
> > occurs when a transaction is being added to a table that captures all
> > transactions for a part master table. The transaction table is linked to
> > the
> > part master table as a 1 to many relationship with referential integrity.
> > What event or where should I put the code to trap this error to present
> > other
> > options to the application user?


>
 
Status
Not open for further replies.
Top