Forcing field to recalculate

[John]

Hi

I have a calculated field on a form which calculates based on values form
two sub forms. How can I force the field to recalculate when data in any of
the sub forms is changed? I have tried myfield.recalc and myfield.refresh
but neither is supported vba.

Thanks

Regards

 

[Maurice]

try: myfield.requery