ok im so im not an access guru. but i have made and inventory tracking system specifically for desktops and printers using auto numbering and a naming convention of WLHWS"000" so i have everything i need my data base to do but one thing. i hope you can help. i have set up a macro ( i think its called ) that when the device status changes to Decommissioned, to delete record.. but we want that name in the auto numbering sequence to select the next available name/number. example Device names 001-010 is active. i decommission 005. new device comes in and i enter it in the data base., but.. next avaliable name is 011 when i need it to be 005. i hope it make sense. anything would help thanks.