NavigationSubForm Reload Data

[bilalo]

I have a NavigationSubForm that targets a report, and outside the NavigationSubForm there is a date field and a button that filters the report according to the date field.
On the click event of the button, I changed the NavigationControl0.SelectedTab.NavigationTargetNam e and NavigationControl0.SelectedTab.NavigationWhereClau se
The problem is the NavigationSubForm will not refresh automatically, I need to click on the selected tab again to refresh the data.
I tried to perform a selectedtab click but it didn't work. Also I tried to requery the NavigationControl0 and refresh the NavigationSubForm but also didn't work.
Is there a way to allow a NavigationSubForm refresh its data after changing its NavigationTargetName and NavigationWhereClause without clicking on the selected tab?

[bilalo]

I found the solution, I used DoCmd.BrowseTo

[June7]

I have read that Me.NavigationSubForm.Form.Requery should work but it does not for me. I tried various versions using Requery, Refresh, Repaint (including Me.NavigationSubform.Requery and Me.NavigationButton7.Requery) - none work. Also tried: CommandBars.ExecuteMso "DataRefreshAll".

Now I see you found solution. What did you use for the BrowseTo arguments?

[bilalo]

DoCmd.BrowseTo acBrowseToReport, "Add report name here", "Main.NavigationSubform", "Add filter here"
Replace Main.NavigationSubform with the path to your NavigationSubform
You could also type Main.NavigationSubform>MyReports.NavigationSubform if you have a NavigationSubform inside another NavigationSubform, in this case you will have to change Main and MyReports with your own pathes

[June7]

Finally figured out the syntax.

So why are you changing NavigationTargetName?