Refreshing Subform automatically

[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

 

[david]

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.