how to refresh a subform

[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

 

[Rick Brandt]

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

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).

 

[Douglas J. Steele]

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.