refresh subform

[pungentSapling]

How can I force my subform to refresh from a cmd button on main form.

the button is supposded to calculate values in the subform based on some queries that run against subforms table,
but it doesn't work until i close and re open the forms. I am assuming that the info is not making it to the table thus not getting into the query.

 

[dgm]

If your subform is called mySubForm then

mySubForm.requery

should refresh the data in your subform.

Dave