Hello,
I have the main form which has a subform at the upper portion and a navigation form at the center, I am having a problem on getting the date difference of 2 textbox consists of the date on 2 different form. I tried several approach and applied it on the control source a textbox where I want to display the result.

Approach 1
=DateDiff("d",[Forms]![HeaderRisk]![DOB].[Text],[Text52])

Approach 2
=DateDiff("d",[Forms]![HeaderRisk]![DOB].[Text],[Forms]![Navigation Home]![NavigationSubform].[Form]![Text52].[Text])

Above approach gives me an error #Name?

I am having a hard time configuring this, please need your help. Thanks in advance.