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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I duplicate a record 1
Need combo box to refresh when moving to new record 2017 1
Basing a subform on a selection from either of two subforms 1
Duplicate record in Form and Subform 0
Append Records from a subform to a new record 1
How and where to capture the "duplicate values" error message? 3
Duplicating error 2
Show record source in a text box 6

Back
Top