Calculated text box recalculation

[ghh3rd]

I have a form who's records source is just a one-row table. Many of the text boxes are calculated on other text boxes on the same form. How can I get the calculated text boxes to "refresh/requery " once their dependent value is changed? Of course, a manual press of F9 does the trick, but I want it to change as soon as a value is changed on another text box.

It seems that I've tried every event and setting, but I know it can be done. It must be the cold wave that just hit Florida that's slowing my brain down today.


Thanks - Randy

 

[CEH]

As the man says..."More than one way to skin a cat"...so different people can tell you different ways.... But first, I would build a query to base the form on. Do the calculations in the query. Then you could use the After update event of the textbox to requery.