Refreshing Subform automatically

  • Thread starter Thread starter David Ehrenreich
  • Start date Start date
D

David Ehrenreich

Hello,

I have a several forms with one that has a subform. The
subform is unbound and based off a query. The form with
the subform is always open. When the table is updated
from other people using other forms, I would like the
subform to automatically update.

Any help would be great
thank you
david ehrenreich
 
Try using on the forms where you are inputting data, in
their AfterUpdate Event

Forms!frmMain!SfrmSub.Recalc

Be careful that you have a different name under the Other
tab in the Property of the Subform when looking at it in
the Main form. If you have the Properties - Data -
SourceObject and Properties - Other - Name containing the
exact same name, then the system will not recognize what
you are trying to do. I usually will put an "S" in front
of the Name in order to differentiate it which is why I
have that in the above example.
 
Back
Top