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
 

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

how to refresh a subform 2
Access Form Refresh 1
Refreshing a subform 2
PLEASE HELP: Refresh a subform 5
Subform Refresh Fails on Opening Form. Works Otherwise. 3
Refresh calling form 7
subform refresh 7
Requerying a subform from another subform 2

Back
Top