Navigation subform Query Criteria

[RayMilhon]

I have an Access 2010 Database that will eventually be migrated to Share Point. I am creating a Navigation system using the Navigation form in Access with a data entry subform and a Reports Subform. In the Reports Subform there is a dropdown for a specific Criteria element. I know that if using a regular form I can put Forms!frmname!controlname in the Criteria of that field in the Report Query and get what I want. I also know that since I'm using a Navigation form there is a 4th Element I need to put in that criteria but I'll be damned if I can remember what it is. I thought it was Forms!NavigationForm!subformname!controlname but that keeps giving me an Error. What am I forgetting here.

Thanks for your help

[June7]

Review this recent thread on similar topic https://www.accessforums.net/access/...elp-27169.html

[RayMilhon]

Thanks June7 I knew I did this before finally figured out where and the thread you referred to matched what I had done previously works great. Thanks again