I have a Quotes table and form, and a Costing form which is based on the
CostsActual table.
On the Costing form I want the various components of our costs to display
the quoted amounts by default, but if these have actually come out different
once we have done the job then the user needs to be able to override the
figures and enter the actual costs.
The source of each Cost control is the relevant field in the CostsActual
table.
In the Default Value properties of these controls I have used DLookup to
pull the quoted costs from the Quotes table and that's fine. However,
although they show as Enabled Yes and Locked No, we cannot overwrite the
displayed amounts.
Am I asking too much, to be able to show a value pulled from one source by
default, but then overwrite it with another value that is input by the user
and which writes to a different table (albeit the table which is the source
for the form)?
Thanks for any suggestions!
CW