Data taken from one record and placed into another record

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

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
 
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
Click to expand...

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.
 
Back
Top