Finding Duplicates

[Ken Smith]

First use the query wizard to find duplicate records.

Then base a subform on the query.

Create a delete query that uses criteria that points to
the subform record's to pick up the id number of the
record you want deleted.

Instead of a command button to run the delete query, you
could set the subform's record event property to run the
query when double clicked. That not only ensures the
record is selected, which identifies the record to be
deleted for the delete query but it triggers the event
without having to move the mouse somewhere else.