Navigation Forms (1 Viewer)

[mike60smart]

Hi

I have no idea on how to reference subforms within a Navigation Form.

The Main Form is unbound and named "Purchasing Form" - Please Note I cannot change any of the Form names used.
Within the Main Form there are a number of Navigation Buttons
The 1st Button is named "Requisitions"
On this 1st Button there is a Form named "NavigationSubform"
Within this Form there are 2 Subforms
Subform1 named "Requistion"
Subform 2 named "Child119"

What I am trying to do is on the After Update of a Date Control within Subform1 I am trying to Requery Subform 2

I have tried this with no joy:-

[Forms]![Purchasing Form]![NavigationSubform].[Form]![Child110].Requery

Any help appreciated.

 

[CJ_London]

perhaps something like

parent.Child119.requery

 

[arnelgp]

navigationSubform only Holds (loads) 1 subform at a time.
so you cannot requery a subform that is not loaded.

 

[mike60smart]

perhaps something like

parent.Child119.requery

Hi CJ
Me Bad as normal.
I have managed to do it now when I use the correct name of the 2nd Subform "Child119" vice "Child110"
Thanks for looking

 

[arnelgp]

if you can requery the 2nd subform, then it is not a "Navigation Form" that you have.
see the last reply of Scott McDaniel in:
Referencing field of a subform in navigation form - Microsoft Community

"Are you using a Navigation form? If so, then you have to handle this somewhat differently. The Nav form uses a single Subform Control and toggles the SourceObject of that control according to the button you've clicked. "