Brendan,
is there a way to recalculate all the forms at once? One click and all the forms do a recalculation would help me a lot with recalculating all the linked forms, now I have to remember to recalculate them all manually. Or am I missing something?
Leo
Hi Leo,
Click on the Refresh button at the bottom of the records list for each form. That’ll cause a recalculation to be done for all the Calculation fields within all the records for that form.
Hi Brendan,
That is what I’m doing…. But many number fields and calculation fields on my forms have affect on linked records on other forms. So I’ll have to recalculate them too. Therefor my question.
Ah I see. Well I hadn’t thought that far ahead with that feature :)
What I need to figure out is a way to recalculate all the referenced linked records whenever you make a change to a value in a form that could affect a formula. But I also don’t want to slow down data entry with all this hunting around for records that might need their formulas updated.
How about just a simple menu item under the tools menu? With a short-cut option-R?
That way the user has control and no affect on speed unless the command is chosen.
Ya, that’s not a bad idea. Then I can loop through all of the forms executing the refresh command. But ultimately it would be better if it wasn’t necessary.
.
