Capture Duplicate Records Error

  • Thread starter Thread starter Bobby Bosco
  • Start date Start date
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
 
You can capture the error in the subForm's Error eventhandler.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top