Capture Duplicate Records Error

B

Bobby Bosco

I have a form that users need to fill out if they got into
an accident. There is a subform (continuous forms) to add
as many riders in the vehicle as needed. I put a unique
index on PERSONID and ACCIDENTID but when the person
selects a name in the combo box, it gets that standard
error that MS puts out. I would like to put out my own
message and then have that record cleared out.

Can this be done?

tia

Bobby
 
G

Gerald Stanley

You can capture the error in the subForm's Error eventhandler.

Hope This Helps
Gerald Stanley MCSD
 
Top