jetbuster
05-10-2013, 07:26 PM
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
DoCmd.OpenForm "Navigation_Tabs", , , CustomerName
doesn't (seem) filter the sub-forms
not sure if this should be obvious or not, I tend to make things difficult for myself :rotlaugh:
When I open the tab control("Navigation_tabs") I want to filter the records to only show the users relevant entries however
DoCmd.OpenForm "Navigation_Tabs", , , CustomerName
doesn't (seem) filter the sub-forms
not sure if this should be obvious or not, I tend to make things difficult for myself :rotlaugh: