Updating a record from a calculated control

[ChrisSedgwick]

Hi,

I have a form that we use for adding orders. The order will contain product lines, so I use a continuous form to do this. At the bottom of the form is a text box that calculates the total cost of the order by taking all the unit amounts.

This box is just used for displaying a figure on a printed report. How would store that figure in the Orders table?

Thanks,
Chris.

 

[Ranman256]

You don't store calculated values. Always calc in a query.

In the form query, put your calculation as a field,
In the footer of the form put a textbox and set = Sum(calcField)

 

[ChrisSedgwick]

Hi,

Thanks for the response. Apologies, I've not explained it well. I have the text box as you've described that is se to Sum - how do I then get the result of this Sum to update in a table?

Thanks,

 

[missinglinq]

...This box is just used for displaying a figure on a printed report...

Then you don't need to do it, in the Form, at all! Use the tools provided in Report Design to do your sums...that's why they're there!

Linq ;0)>