I have a form called frmNavigation. It was created using the form template for navigation. It has the NavigationSubform control, which states its type as subform or subreport. The control has several forms as targets. All I want to
do is requery and refresh one of those forms. I have this:
Forms![frmNavigation]!NavigationSubform.Form.Requery
Forms![frmNavigation]!NavigationSubform.Form.Refresh
based upon one of the posts I found on this site. It is the only combination of code that does not throw errors. However, it does nothing.
Any time i try to reference the target form by name, an error message tells me the form cannot be found. I have tried looping through NavigationSubform controls to find any acform contained in that collection and assign it to a form object. The
code finds none.
Please advise me on how to reference this form so I can requery/refresh it.
Thank you.