I currently have A form to input some data into a table. each record has an ID number which simply displays the current record number (ie. 1,2,3,4,...20,21,22...) When I delete a record there is a gap between the numbers (i.e. deleting record 2 would give me 1,3,4,5....). What I am looking at doing is simply to update the records after the deletion so that my table has no missing ID numbers (i.e. 1,2,3,4,...).
I have looked at using a query to update the values but I have been unable to do this because I cannot get it to recognize which value is missing.
I have also looked into adding part of vba code after the record has been deleted.
What is probably best?, and how do I do it? I am still a newbie at access...