MS Access 2007 reference subform control on tabbed control returning null

0
votes

I have a subform reference returning Null where the textbox has a value in it. The code I am using is:

End Date: [Forms]![ReportCentre]![NavigationSubform].[Form]![txtEndDate]

This is in a tabbed control, but I could not find the .Pages property referred to in a similar question.

The subform being referenced is [LODForm], and the tab control (page area) is [NavigationSubform]

Why is this returning Null?

1
ms-accesscontrolssubforms

1 Answers

0
votes

The subform belongs to the form, not the tab control. The tab control only hides/displays other controls. And you will reference the subform control, not the subform. Thus:

End Date: [Forms]![ReportCentre]![NameOfYourSubformControl].[Form]![txtEndDate]

Inserted name of subform control:

End Date: [Forms]![ReportCentre]![NavigationSubform].[Form]![txtEndDate]