By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,293 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Access id problem

P: 20
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 Images
File Type: jpg id problem.jpg (22.5 KB, 185 views)
File Type: jpg id problem 2.jpg (4.2 KB, 115 views)
Apr 16 '10 #1

✓ answered by Denburt

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.

Share this Question
Share on Google+
2 Replies


Denburt
Expert 100+
P: 1,356
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.
Apr 16 '10 #2

P: 20
Thanks It helps
Apr 21 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.