Form Update (1 Viewer)

[Misterpiz]

Good Morning,

I have a form that as several fields that "mathematical" calculations. For instance, I have a Billed, a Rate and Margin text box. If I update the Billed value, the Rate and Margin values should update, but they do not. I have tried using after update even me.requery, me.recalc. and me.refresh.:banghead:

Any thoughts?

Misterpiz

 

[Ranman256]

if its on the form, set the text box control source to the other form textbox names:

txtSpeed = txtDist / txtTime

 

[Misterpiz]

if I change the control source, how will it be saved to the table that I am needing the information to be stored?

 

[Minty]

In theory unless these calculated values are time critical (e.g. could change over time) you shouldn't store them, as they can always be calculated.

If any of the underlying values change then you need to somehow capture that and re-save the new value, which is messy.