Karl,

I've seen this message lots of times, and 100% of them were the following
case:

I was referring to when the duplicate "record" is not even a record
yet...e.g. someone just entered a new record with a manually entered PK, and,
when you they to move off the new record (i.e. when Access woudl otherwise
enter it) , Access rejects it and gives this error message.