Prevent Subform Refresh
Posted on 2011-10-26
I have a rather complicated form with a large number of subforms. Calculations on one subform require that values on the parent form be updated. This occurs after any variable on the child subform is changed. After each update, I refresh the parent form to display the results.
However, most of the subforms contain historical data. And if there is a considerable amount of historical data, i.e., 30,000 records, each refresh becomes painfully slow.
Is there a way to refesh just the parent record without refreshing all the child subforms? Most are static and don't need to be refreshed. I have tried unlinking the subform, disabling the subform, and limiting the recordset to the last 500 records. But none of these options seem to help.