Quick question

[ABreeze]

If your text boxes' control source is a calculation, how can you save the result to a table? Can you? Thanx.

 

[Rich]

As a rule of thumb you shouldn't, just recalc whenyou need to display the value

 

[Dave Eyley]

Yes you can...

If you have a result field whose source is a table field.

So if you had say,

Field 1 = UnitCost
and
Field2 = Tax

then have as the AFTERUPDATE code on Field2 -

Total=UnitCost*Tax

where Total is the Table Field3


That should do it....


Dave E

 

[Rich]

Yes and if you want to commit suicide some will try and talk you out of it, others will load the gun for you.
Best of luck

 

[Dave Eyley]

It's funny how some people give you what you ask for and some people give you what they think you need, isn't it?

Dave E

 

[ABreeze]

Thanks....I think.

I normally would recalculate but in this instance I have to store the result for each record in order to do further calculations. It's a bit complicated. If I could think of some other way to do it I would. Thanks again...