hi i have a DSum calculation in a field on a form, but it does not change unless i open and close the form, how can i prevent this? another problem is that because it is unbound (but has a formula) it does not record the value in the table... is there any way of getting around this?
DSum???
- Thread starter redblaze
- Start date
reel knotty
Registered User.
- Local time
- Today, 13:48
- Joined
- Jun 5, 2002
- Messages
- 71
I seem to be answering questions with other questions today but .... why would you need to save the value of you expresion back into your table? If you have the data in the table to create your answer there is no need to save it back to the table. It only makes your table more combersome. IE Doubling your information with out gain. and to fix you Dsum problem try a requiry macro
Fizzio
Chief Torturer
- Local time
- Today, 13:48
- Joined
- Feb 21, 2002
- Messages
- 1,884
If the controlsource of the control is the DSum then it should change as the rest of the values change. You could try
me.refresh or me.recalc (to refresh the values in the form / recalculate them) on the after_Update of the field based in the calculation. Why do you need to store the value when you have already proved that you can calculate it?
It may be easier to post where the DSum calculation is (ie, controlsource, Default Value or calculated by code) and the actual DSum expression
Also, the Dsum will not be refreshed until the record is saved.
me.refresh or me.recalc (to refresh the values in the form / recalculate them) on the after_Update of the field based in the calculation. Why do you need to store the value when you have already proved that you can calculate it?
It may be easier to post where the DSum calculation is (ie, controlsource, Default Value or calculated by code) and the actual DSum expression
Also, the Dsum will not be refreshed until the record is saved.
Last edited:
