Problem with entering data via form in Acess database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how I can fix my problem with an Acess 2003 data base form
where the auto generated number and the record number down the bottom are one
out for each form entry. ie:

Number 72 reads 72, but then it skips to
73 reads 74
74 reads 75 and so forth

Help....please....
 
Ignore these numbers, they are meaningless. The Autonumber field will not
always be totally sequential. If you delete the row with the Autonumber
field = 75, then you will see 73, 74, 76. Autonumbers are really only good
for a couple of things. One is to use them as relational pointers and
another is if you want to order a table by when each row was entered.

The record numbers on your form are also irrelevant. It just shows the
relative position based on the current order of the recordsource. Also, if
you have any filtering set, then records filtered out will not have a number.

To avoid this confusion, my practice is not to even show those numbers on a
form.
 
Back
Top