I was originally using row_ID() but because of another ongoing problem I encountered where the row_ID jumped several numbers ahead as if multiple rows were added then instantly deleted, I had to switch to Autonumber.
The problem still occurs with Autonumber, but at least I am able to reset the numbering, while I cannot recover the missing rows.