| | |
|
|
|
Data taken from one record and placed into another record |
|---|
| message from Jon on 12 May 2004 |
I have a database that mysteriously takes information from
fields in one clients record and places it into the fields
of another client record. This happens sporadically. I end
up finding data all over the place.
Has anyone experience this? Is there a way to fix the
problem
|
| John Vinson replied to Jon on 12 May 2004 |
You MIGHT have some corrupt indexes (so that Access thinks it's
bringing up one record but it's bringing up a different one).
It's also possible that PEBKAC - Problem Exists Between Keyboard And
Chair. If, for example, you're unintentionally overwriting one
client's Primary Key field with a different one, you'll get this
happening. One way this could happen is if you use a *bound* combo box
on a Form to navigate to a different record - if it's bound, it will
overwrite the current record's ID with the selected one.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
Archived message: Data taken from one record and placed into another record (MS Access Error Message)
