Recalculate fields in a subform.

[turks67 via AccessMonster.com]

Is it possible to update the fields on a subform from a command buttom on the
main form?
I'm trying to recalulate the fields on a subform if someone changes the
numbers.

 

[John W. Vinson]

Is it possible to update the fields on a subform from a command buttom on the
main form?
I'm trying to recalulate the fields on a subform if someone changes the
numbers.

Sure. This can probably be done with a macro, but the VBA code would be

Private Sub RecalcMySub_Click()
Me!subformname.Form.Recalc
End Sub

where subformname is the name of the subform control (not necessarily the same
as the name of the form object within that control).

Depending on the nature of the changes you may need to use the .Refresh
method, or possibly two lines, a refresh followed by a recalc.