Deleting Duplicate Records in a Form

  • Thread starter Thread starter Josef
  • Start date Start date
J

Josef

hi,

i have a form with 4 fields. when trying to add new records in a form i
am not notified if i am adding duplicates.

is there any way of detecting when a duplicate record is going to be
added and how can i notify the user and clear the form before a record
has been added.

i have set an autonumber that defines the record.

i would like the procedure to detect for duplicates after an item has
been selected from the last field and the user presses the enter key.

thx
 
The easiest & likely best way is through setting up an
index on the table where this data will be submitted to.
It is simple and very effective, as I use it all the time.


Open the table in Design view.
Click Indexes on the toolbar.
In the first blank row in the Index Name column, type a
name for the index. You can name the index after one of
the index fields, or use another name.
In the Field Name column, click the arrow and select the
first field for the index.
In the next row in the Field Name column, select the
second field for the index. (Leave the Index Name column
blank in that row.) Repeat this step until you have
selected all the fields you want to include in this
index.
 
Back
Top