Form showing incorrect data

[Guest]

I've tried searching on this topic, but can't seem to find any help on it.

I have encounted this problem both in a table and a subform based on that
table. Every once in a while (quite unpredictably, I'm afraid), Acess decides
to copy the data immediately adjacent to a record I'm trying to edit (ie: the
record directly above it). For example, if I've decided to change the name of
a product, I type in my changes, hit the tab key to go to the next field, and
Access hasn't entered the changes I've made, but rather has put in the data
from directly ABOVE it. I don't get it!!

I've also experienced this in a subform on my Invoices form. When I looked
at the actual data in the Invoices Table, however, the data was correct, it
just looked like the previous record. What have I done! Or what can I do to
remedy this?

 

[Guest]

This can be caused when the Ctrl key and '(@) key are pressed at the same
time. It is a microsoft shortcut which selects the data from the same field
in the previous record and pastes it in the current field.

Not sure if this helps but it could be the cause of your problem

 

[Guest]

Thanks, but I'm definitely not hitting any extra keys. I have discovered,
however, it's after I've started a record in that form, if I close it and
come back to add more to it, that's when it starts copying the previous
record. As soon as I hit 'Refresh' it shows my data the way it should be. I
don't understand why this keeps happening!