How to Recalc all records in a subform on open?

[DwayneS]

I have a form with a subform. I am using SQL to populate the table which is the source of data for the subform. When I open the main form, I want the subform to update its calculations (I'm calculating a lot of numbers and displaying them for the user). Presently, I need to at least "touch" each one before I can get them to recalc. Is there a simple and reliable way to recalc all the sub records on open?

Dwayne Streeter, CPA, CITP

http://www.cpe-interactive.com

 

[Pampers]

Maybe you can try on the Open_Event of the subform:

Me.Recalc

Pampers
Just let it go...

 

[DwayneS]

Duh! Thanks. I bet it works.

Dwayne Streeter, CPA, CITP

http://www.cpe-interactive.com