apply filter macro not working in subform after I've changed where condition for filtering to email

[jmharris]

I use a apply filter macro with where condition [ID]=[Forms]![Main Form]![ID] which for me translates....[ID]=[Forms]![Request for Purchase]![ID]
When I move the form to navigation the macro stops working. I have tried many different combos in the macro for use of subforms in main form...i.e.
[ID]=[Forms]![Ops Navigation Form]![NavigationSubform].[Form]![ID]
[ID]=[Forms]![Ops Navigation Form].[Form]![ID]
[ID]=[Forms]![Ops Navigation Form].[Form]![NavigationSubform]![ID]


[Forms]![Ops Navigation Form]![NavigationSubform].[Form]![ID]
[Forms]![Ops Navigation Form]![NavigationSubform].[Form]![request for Purchase]![ID]
and so on. And error comes up every time that there is no data base availible for the filter. The email object macro works fine without the filter but then it ends up emailing the whole set of forms (continuous).
The form "request for purchase" is based on a table with info on it. I have placed that form along with a few other forms similar work order forms in a navigation form. I don't really know VBA but can copy and past really well if I know what names to change.
Can someone tell me what the where condition needs to be for filtering to the current subform or create a current form pdf to email?

[NTC]

well aspects of your post are not clear; one can control a form's display of information at 2 different points; the record set (i.e. query that it is based on) or a filter

a sub form, if it is bound to the main form is going to be defined by that cross referenced field

[jmharris]

well aspects of your post are not clear; one can control a form's display of information at 2 different points; the record set (i.e. query that it is based on) or a filter

a sub form, if it is bound to the main form is going to be defined by that cross referenced field

-I don't have a query. It is a filter of a subform bound to the main form I imagine. The code works fine when used just in the main form (filter form macro then email database object "form"). But I don't know how to define it all in the subform.

[jmharris]

I don't know if it helps but here is a picture of the form...