Help needed with recalc on subform.

  • Thread starter Thread starter FatMan
  • Start date Start date
F

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
 
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.
 
Back
Top