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?