If you do not have many updates, and (as i think to have understood) your field is a key field...something like 'SELECT MAX(myautofield) From MyAutoTable' will work fine...
If you have many updates, forget the autonumber feature and use an external counter table...