"Refresh All" in VBA

[aytee111]

Is there a way to code the "Refresh All" ribbon button? I have a form with multiple subforms and would like to refresh them all at the same time, just like the ribbon button does. The user can add subforms as desired but does not have the ability to go into the code, so I would prefer to avoid requerying them one by one.

[amrut]

Try Me.Requery in your main form in an appropriate event .

[aytee111]

Tried that - that only applies to the main form.

[amrut]

you can query the subforms too. Me.YourSubformControlName.requery

[aytee111]

Like I said, I don't want to do that. I am trying to find out if what I am asking is possible, I know there are lots of workarounds.

[amrut]

Try CommandBars.ExecuteMso "DataRefreshAll"

[aytee111]

Brilliant! It worked, thanks a lot.

[amrut]

Glad to help, Here is the trick to execute any commands in ribbon. Goto File>Options>Customise Ribbon.hover the mouse on a command in the left side box, the value in parenthesis is the string ID for a command to execute.

Commandbars.Executemso StringID

Mark the thread as solved.