how to refresh a subform

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
 
R

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

refresh only the subform 1
PLEASE HELP: Refresh a subform 5
Refresh calling form 7
refresh/requery subform 2
Populate main form from subform record 0
Refresh All 2
refresh subform control 1
Refreshing a subform 2

Top