Dupplicate records

T

tiyago

I have a form that its source is a table, the table contains 4 fields. I
would like to check if a record that just entered is a duplicate and if so to
use my own MsgBox.
I know that in table design I can create multiple-field indexes. I have done
that, but I don’t want to see the default pop up message in case of a
dupplicate record. I want to create my own message and delete the record
(using visual basic)

Thanks,

Tiyago
 

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

Copy previous record into form field 0
Delete query...... 1
DMax on existing record to increment serialized # fails 1
Access 2010 DB not fuctional with multiple users 2
Duplicate record detector... 0
Two Delete Record Problems 1
Insert Index into a Table 1
Using DSUM to get running total on a filtered form 0

Top