Requery Subform upon clicking a button in the main form.

[SwatiGV]

I want to update the subform upon clicking a button (Run) in the main form. The Run button on the main form is updating a query(Filter Region). This query is the Source Object of the Subform.

The query is getting updated upon clicking the Run button but the Subform is not. The code written for the Run button on the main form is:

Private Sub Run_Click()
DoCmd.OpenQuery "Filter Region", asViewNormal, acReadOnly
End Sub

I think, by modifying the code of the 'Run' button we can update the subform.
Please suggest.

[mbizup]

Try adding a line of code to your sub, after the OpenQuery. The general syntax for a main form requerying a subform is:

Me.MySubformControlName.Form.Requery

Where MySubformControlName is the name property of the control that houses your subform (in the main form's design view). This is usually, but not always the same as the name of the subform as seen in the navigation pane/database window.

[jforbes]

In this case, the SubForm is calling the Query and displaying the Results, so you'll want to tell the SubForm to get the latest results. Something like this should work for you.

Me.NameOfSubForm.Form.Requery

You'll need to replace the NameOfSubForm with the real name of the Control that contains the SubForm. ...It really needs to be the Controls name.