how to refresh a subform

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
J

Jean-Paul

Hi,
I have a form with a subform.
I only want to refresh the subform and not the wole form..
However, I can't find the correct syntax

This is what I tried:

Forms![Bedrijven].Form![Sub_bedrijven].Refresh

It doesn't work so.... any idea?

Thanks
 
Hi,
I have a form with a subform.
I only want to refresh the subform and not the wole form.. However, I
can't find the correct syntax

This is what I tried:

It doesn't work so.... any idea?

Thanks
Click to expand...

Forms![Bedrijven]![Sub_bedrijven].Form.Refresh

This assumes [Sub_bedrijven] is the name of the subform *control*, not
the name of the form contained within (often the names are the same, but
not always).
 
Assuming that the name of the parent form is Bedrijven and the name of the
subform control that holds the form being used as a subform is
Sub_bedrijven, try

Forms![Bedrijven]![Sub_bedrijven].Requery

If that doesn't work, try

Forms![Bedrijven]![Sub_bedrijven].Form.Requery

You may find http://www.mvps.org/access/forms/frm0031.htm at "The Access
Web" a useful reference.
 
Back
Top