You'd have to delete record 10, then compact to get it to reset BUT AutoNumbers aren't for you.
AutoNumbers Good or Bad?

Asked and answered - many times.  Please take a look through the posts and videos.

Short answer is that Access uses the AutoNumber to maintain uniqueness of records.  It is NOT for you to use.  Not something to rely on in any other way except to relate records together. Access is doing exactly what it is intended to do.  Once used it never reuses that number even if you cancel.

There are videos on here that also give you a way to give custom numbering for your customers if you need a solution for that.
I'm not at a place to look them up right now but if you would like some pointers just holler and I'll dig them up for you.

There has been a lot of these lately on autonumbers. Long story short, you should not be using autonumbers for anything, they are only for access to keep track of records. Whatever number they are at should not matter to you at all.

If you need to have an "autonumber" that you actually use for invoice numbers or something. See this Custom Sequential Number

Custom Sequential Number

Wow! Thanks everyone really appreciate the help. Apologies for failing to locate that myself. I now have a new problem. So, I'm doing all this to organize maintenance. My maintenance personnel can now open up the database, click a button and it pops up a form to fill out for what PM they performed and when they performed it and that goes into a running log. I also have a table that lists every machine and every pm on that machine and how often it needs to be done such as every 30 days. I need to make some kind of data table that will show me what PM's are overdue by comparing the running log of PM's to how often they should be done. So I am trying to find a way to compare the column named "DateCompleted" from "tblPMlog" to the column of "frequency" from "tblPmTaks" and today's date. I have been messing around with queries but I'm not sure it can do what I'm looking for maybe it can and I just don't understand the full potential. Any suggestions on how to go about doing this?

Make a query expression that does Date() - DateCompleted , say we call it DaysSinceComplete

Then Make another expression like IIF(DaysSinceComplete>Frequency,"OverDue","Current")   IIF Function

Worked brilliantly. I think I only have one last question. Right now, I have a table which has the machine, then PM to be done on it. So, the machine name repeats for every PM that is for that machine. I want a combo box to pull the machine list with no duplicates, right now I have a separate table that lists the machines so it doesn't pull duplicates, but then I want the PM combo box to only display PM's for the selected machine. Right now I just have it displaying every possible PM. Is this possible? For the row source of Machine combo box: SELECT [tblMachineName].[Machine Name] FROM tblMachineName; then PM combo: SELECT [tblTask].[Maint Point] FROM tblTask; I tried SELECT [tblTask].[Machine] FROM tblTask; for the Machine combo box but it just repeats the machine name over and over. I watched the relationalcombo video and combovaluelist video but didn't seem to answer my question.

Try adding a SELECT DISTINCT ...

Aggregate Query