Auto numbering field does not protect you from logical duplicates. It just simply provides a new unique value for your record.
To enforce uniqueness for a set of columns you need to either create a unique constraint or index.
For the syntax for creating a unique index, have a look at
CREATE INDEX Statement (Microsoft Access SQL)[
^]