I want to use a navigation form to filter one form/query.

[wchelly]

Essentially what I want to do is use the tab caption as the criteria for the query. So that if I click one tab it will use one criteria, but if I choose another it will use that criteria. Is that possible?

I understand that I can create a macro and open the form with a filter. But the reason that doesn't work is because I do not want to open the form. I want it to open the form as a subform and then change the data in the query as I click different tabs.

 

[wchelly]

Oh nevermind, I was making it too complicated. I realized that I just need to go into the Data Properties and point it to the correct Navigation Target, and then Point to the Navigation Where Clause

 

[wchelly]

UGh...that didn't work. Now I'm back to the query idea...