Calculated Controls for Data Entry

[Monterey_Manzer]

Hi,



Okay so I've got some fields that need to be filled out pertaining to financial issues that I hope to make easier and more efficient. I have one field that represents the "Base Cost" that I expect to fill in myself. The second field is a calculated "Acceleration". This value is almost always 0.3*[Base Cost]. I can enter =[Base Cost]*0.3 in the control source for the field in my form and it looks great in the form...but I need this data to save the "Acceleration" value to the record in the table. A second concern is that occasionally there are deviations from the [Base Cost]*0.3 formula and I need to be able to enter those and have it save to the table. The same applies to my "Total Cost" field, which is simply =[Base Cost]+[Acceleration]. I put this into the calculated control and it works just fine but doesn't save in the corresponding table. Any thoughts?

Thanks!

[pbaldy]

This should help:

http://allenbrowne.com/casu-14.html

[Monterey_Manzer]

Thanks! This does help quite a bit.

[pbaldy]

No problem! If your alias refers to Monterey CA, I might be down there in a couple of weeks. Beautiful area.