How To Perform Search From Navigation Form

OK, do I just learned about the new feature in Access 2010. I have my setup all complete and everything works great. Now, I have a subNavigation form within the Navigation form. Thing is, I am not sure how to go about the code for the query to pick up the Beginning and End Date to generate my report. Here is my Form setup:



frmNavigationForm (Main form) - Tabs on top.

NavigationSubform (first Navigation Form, where I have a tab called Admin)

frmAdminNav (where I have embedded under the Admin tab) - Tabs on left side.

NavigationSubform (Second Navigation form where I have a tab called "Search") I don't recall what the name. How do I find it, stupid question, I know...

frmSearch (where I am trying to pull a detailed report from date search criteria)



Here is one of the codes I have been trying to use in my Query and nothing seems to work.

Code:

---

Between [Forms]![frmNavigationForm]![NavigationSubform].[Form]![frmAdminNav].[Form]![frmSearch]![BeginDate] And [Forms]![frmNavigationForm]![NavigationSubform].[Form]![frmAdminNav].[Form]![frmSearch]![EndDate]

---

Any ideas?

Thanks

How To Perform Search From Navigation Form