calculated field in form - to table

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

My main form (form1) comes from a table (DSD Final). Some of the fields in
the form are a calculated control source. I would like to replicated these
fields and have them replications update to the table. Is there anyway to do
this, without re-doing my queries (which I would do the calculations there)?
I've tried using a list & combo box, typing in the field name (text75) as the
value I want stored in my table, but this isn't working.
Any suggestions??

Thanks,
Jennifer
 
You can use Set Value to do it but that is bad. Search on 'store calculation'
to see experts opinion about it being bad idea.
If any data changes then the calculation is no longer valid.
Best way is to do the calculation each and every time it is needed.
 
My main form (form1) comes from a table (DSD Final). Some of the fields in
the form are a calculated control source. I would like to replicated these
fields and have them replications update to the table. Is there anyway to do
this, without re-doing my queries (which I would do the calculations there)?
I've tried using a list & combo box, typing in the field name (text75) as the
value I want stored in my table, but this isn't working.
Any suggestions??

Thanks,
Jennifer
Click to expand...
Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.

Just redo the calculation whenever you need it, either as a
calculated field in a Query or just as you're now doing it -
in the control source of a Form or a Report textbox.

If you feel that you have an exceptional situation please explain.
 
Back
Top