I am trying to insert a chart in a form.
The form has text boxes which calculate totals, and I would like to make these totals the source of the chart.
The totals are currently not part of any table.
I have tried to instead of putting the totals in text boxes, to use fields from a query. This kinda works but it takes for ever to update when I make a change to the amounts.
Does any one know how to get round this?
Thnx
The form has text boxes which calculate totals, and I would like to make these totals the source of the chart.
The totals are currently not part of any table.
I have tried to instead of putting the totals in text boxes, to use fields from a query. This kinda works but it takes for ever to update when I make a change to the amounts.
Does any one know how to get round this?
Thnx