D
Dave Couch
First, yes I have read the threads on storing a calculated field and that it
is bad mojo to do that. However, I have pay data that I calculate and input
to a database and it must be able to be reconciled with our ADP data. So I
need the ability to change and fix the data so it does not change as a result
of recalculations. I have a form with a field that calculates the pay based
on hours and pay rate. I have another field (the "copy" field) next to that
one that has the control source set to the database field. I have set the
default value of that field to be equal to the calculated field. When I
first go into the form, the "copy" field is updated with the calculated info.
However, if I change the input data and the calculated field updates, the
"copy" field does not. How can I get the "copy" field to update. By the
way, Access 2003 on WinXP.
is bad mojo to do that. However, I have pay data that I calculate and input
to a database and it must be able to be reconciled with our ADP data. So I
need the ability to change and fix the data so it does not change as a result
of recalculations. I have a form with a field that calculates the pay based
on hours and pay rate. I have another field (the "copy" field) next to that
one that has the control source set to the database field. I have set the
default value of that field to be equal to the calculated field. When I
first go into the form, the "copy" field is updated with the calculated info.
However, if I change the input data and the calculated field updates, the
"copy" field does not. How can I get the "copy" field to update. By the
way, Access 2003 on WinXP.