mike60smart
Registered User.
- Local time
- Today, 11:29
- Joined
- Aug 6, 2017
- Messages
- 1,914
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.
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.