Forms

[Guest]

I have created an expression in the control source in one my fields in form
view. The expression works on the form but does not calcualate onto my
table. Any suggestions to fix this problem.

Thanks

John

 

[Rick Brandt]

I have created an expression in the control source in one my fields in form
view. The expression works on the form but does not calcualate onto my
table. Any suggestions to fix this problem.

In almost all cases if you can calculate the value then you don't need to store
it and it is considered bad database design to do so.