Hello,
I am trying to finish up a program for my company and am trying to add a record number field ie... record 1 of 20.
I am using .recordcount for the "of 20" part and am using the id field from my access database for the record number. However, when I delete a record, the id field does not update ie... I have 5 records. id is 1,2,3,4,5 then I delete record 3, the 4 records left id's are still the same ie.. 1,2,4,5. How do I get the id field to update as well as the total record count. I am probably going about this the wrong way, so any input or alternate suggestions are much appreciated.
Thank You,
Rene
I am trying to finish up a program for my company and am trying to add a record number field ie... record 1 of 20.
I am using .recordcount for the "of 20" part and am using the id field from my access database for the record number. However, when I delete a record, the id field does not update ie... I have 5 records. id is 1,2,3,4,5 then I delete record 3, the 4 records left id's are still the same ie.. 1,2,4,5. How do I get the id field to update as well as the total record count. I am probably going about this the wrong way, so any input or alternate suggestions are much appreciated.
Thank You,
Rene