So I have a main form which you choose a customer from a combo box and I have a tab control with a few sub-forms(one in each tab) which are all linked to the customers by their ID's.
When I open the tab control("Navigation_tabs") I want to filter the records to only show the users relevant entries however
[vba]DoCmd.OpenForm "Navigation_Tabs", , , CustomerName[/vba]
doesn't (seem) filter the sub-forms

not sure if this should be obvious or not, I tend to make things difficult for myself