Access id problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cynicon
    New Member
    • Feb 2010
    • 20

    Access id problem

    Hi everyone, so lets I have a form in access and I use the autonumeric id for each record I capture,

    Somehow now, when I open the form the ID doesnt match anymore with the ID that access shos at the bottom, I have erased the table and upload it again, but the form still have this error, does some knows how to fix it?

    Thank you guys
    Attached Files
  • Denburt
    Recognized Expert Top Contributor
    • Mar 2007
    • 1356

    #2
    OK first the number at the bottom shows you how many records or entries you have in the table currently. The number or ID at the top shows you how many records have been entered over the course of the tables lifetime, so if you delete one or more records then add more, the number or ID at the top will always increase irregardless of the number that is actually in the table at any given time.

    Comment

    • cynicon
      New Member
      • Feb 2010
      • 20

      #3
      Thanks It helps

      Comment

      Working...