If I run the queries before the rest of the code starts, aren't the records "old", not "new"?
First, I didn't copy the On Error line to what I posted. In my code I have it remarked out so if there is an error I could see where the error occurred. No errors. I'm always open to learning which is why I posed this asking for help. Again, the record count was just for me to use when testing to validate the correct number of records in the table. I'm sorry I appear to be strange. I try not to be.Honestly, this whole code block seems strange. Stuff is in the wrong place or the wrong order like the .movelast and .movefirst coming after you try to set the recordcount. You have detailed error handling but no On Error in the appropriate place. You have an If/Then code block checking a local boolean variable that isn't set or changed anywhere. You have a fairly detailed/complex block of code including conditional operators but don't know how to use the debugger? It all seems a bit strange.