refresh only the subform

[Jean-Paul]

Hi,
I'm struggeling with the corrct syntax of refreshing a subform...
Can somebody help?

My code (which doesn't work)

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

 

[Rod Plastow]

Hi Jean-Paul,

Where exactly are you running this code? Is it from the main form or is it
external to both the main and sub form?

If it's from the main form then the syntax is something like:

Me.[NameOfTheControlThatContainsMySubForm].Form.Refresh

Substitute the name of your control for the second term above.

If it's external then:

Forms![MyFormName]![NameOfTheControlThatContainsMySubForm].Form.Refresh

You'll get a nasty error message if the form is not loaded.

Rod