refresh only the subform

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

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
 
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
 
Back
Top