Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access Form - New ID incorrect when trying to enter a new record

Hi

In my Access tabular form which is  bound to a table called "Parts" when I go to enter
a new record where it says "(New)" the ID that is generated is not a new ID but rather an existing older ID.
Why would this happen?

User generated image
SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murray Brown

ASKER

Hi. Thank you both. I have been using Access since 2005 and never seen this issue, I wonder if the database being in Dropbox may have been the issue
"I wonder if the database being in Dropbox may have been the issue"

Yes, I would not consider using Dropbox as the storage location for a BE for my database application.

Dale