Then you need to see if there is code running behind the form triggered by
you changing fields/moving focus, that runs and sets the value of the
so-called fields. Also check the table(s) that the form is based on to see
if there are default values set during design time. Open the table in
design view to check. Other then that I've never heard of data magically
appearing in records from adjacent records. One other thing you can try is
open the table directly and try changing/adding records and see if you get
the same results. If so it's default values set in the table or
relationships. One other thing I forgot to mention, if this is a multi user
database, maybe someone else is changing the data.
--
Reggie
www.smittysinet.com
----------
"Jon" <ca*****@hotmail.com> wrote in message
news:da**************************@posting.google.c om...
"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:<5i*****************@news-server.bigpond.net.au>...
Jon wrote: 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
At a guess it has something to do with how the data is entered. You'd
have to give more info:)
In this database you can input information into a field and on the
selection of another field, notice that other fields have magically
brought information from other records into it. These is no link to
bring other information into the current record.
I am led to believe that information is being transferred
automatically to and from adjacent records without request. This seems
to be the main problem that exists.