How To Perform Search From Navigation Form

[skilche1]

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.

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

Any ideas?
Thanks

 

[spikepl]

Google
access expression builder

And use it to build a reference

"Nothing seems to work" is BS. Either it does what you want or it doesn't. No "seems". And " nothing" contains 0 clues as to what you actually attempted.

Read my signature.

 

[skilche1]

Google
access expression builder

And use it to build a reference

"Nothing seems to work" is BS. Either it does what you want or it doesn't. No "seems". And " nothing" contains 0 clues as to what you actually attempted.

Read my signature.

Yes, I have tried this. I finally got it..

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

All set