Many thanks for your prompt reply...yes I do have the Control Sources set,
they point to the relevant fields in the CostsActual table.
That's cos the way I want it to work, users will initially (by default) see
the quoted amounts which are being pulled from the Quotes table. But if the
actual amounts have come in different, they need to input those and have them
stored in the CostsActual table. In this way, we can work out variances
between amounts allowed for within our quotes (stored in the Quotes table and
not overwritten) and the actual cost amounts (newly stored in the CostsActual
table).
Hope this clarifies what I'm trying to do, and why. The question now is, HOW
?!
Thanks again
CW

"Linq Adams via AccessMonster.com" wrote:

A Default Value can be overwritten by manually entering new data, so you
shouldn't be having a problem. On the other hand, setting the Control Source
to something, like a value retrieved using DLookup(), cannot be overwritten.
First thing I'd do is look at the Control Source and make sure you didn't
place something there during the development process and forget to remove it.

Is the form updatable, i.e. can you enter and save other data?

Other than that, based on the facts you've given, I'd have to lean towards
corruption of some sort.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1