Help needed with recalc on subform.

[FatMan]

Hi all:
I have a form with a subform on it. I would like to know how I could cause
the subform to recalculate when a control on my main form has been updated.

The main form name is: frmSprayRec09Add
The control that is been updated is: txtDate
The name of the subform is: tblProducts subform

I have tried entering me.recalc in the "after update" event on the control
txtDate but this only causes the main form to recalculate. How do I
reference the subform and cause it to update?

All help is greatly appreciated.

Thanks,
FatMan

 

[Maurice]

in the afterupdate of the textbox try:

me.[tblProducts subform].requery

hth

 

[PJFry]

What is supposed to happen when you enter the date? For example, are there
fields in the subform that use that date as part of a calculation, like in an
aging calculation? Or is that data a parameter for filtering a set of
records, say, show me all the sales on 4/2/2009?

The answer will help us figure out if you need to recalc, refresh, requery,
etc.