duplicate records in access

[Anonymous]

I'm writing an application to extract attribute values from an AutoCAD dwg and placing them in an Access database.
My question is this:
How can I check a specific filed in the data base for duplicate records using VBA?

[Anonymous]

Select * from AutoCADObject = 'CurrentObject'

Check the recordset to see if there are any records if there is then you have a match