Any way to pin point what you are talking about
You mean to find whether or not you have a form control bound to an AutoNumber column?? Well you'd have to examine your form properties and dropdown lists (which lists all controls on the form), check out each control's Controlsource, if you don't remember, and evaluate whether or not its bound to an Autonumber column...
I don't usually use any of the built in Wizards to generate command button code, but I'm just thinking of it from this perspective:
- If your command button tries to duplicate EVERY field on the bound form to a 'new' record, and if one of those fields is bound to an Autonumber column, then that should err out, because you can't explicitly duplicate an Autonumber column (that being the point of Autonumber columns).
- Whereas, Access is smart enough (I use that term loosely), to handle things differently when you Select a record in a datasheet view table, Copy, and Paste it. It doesn't really Paste everything...it actually increments the Autonumber.
See what I mean?
This may not be your scenario - I was just taking a stab at it. What's the code behind the duplicate record command button?