Trini Gal wrote:

Thank you for answering. Honestly, I have read so much about why I should
and shouldn't be using the AutoNumber, that I just didn't use it and used the
DMax function instead.

FWIW I've been using autonumber keys for three decades both in Access
and previous environments. Some of my systems are in use by 25 and
30 users all day long. And I can't recall any problems with using
autonumbers.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/