I am trying to make a navigational form with tabs that contain information on
a particular record. My first tab in the form is called "products" and my
second tab is "inventory". The problem that i am getting is that when I
change my record in my products tab and i goto my second tab "Inventory" it
resets to the first record in my querry. I would like to click on the
"Inventory" tab and it be related to the "Products" tab record that i have
chosen.
More Info
I have made two seperate forms one called, "Products" and one called "Inventory". They both retrieve data from the same querry that combines the data from 3 different tables. The forms independantly work ok.What I did was made a new navigational form (horizontal tabs). I dragged and dropped of these forms to make two sepperate tabs. Now i have been told it has to do with the master/child relationship in subforms. But when you drag them into navigation they become a form for each tab. Is there a way of linking them?
a particular record. My first tab in the form is called "products" and my
second tab is "inventory". The problem that i am getting is that when I
change my record in my products tab and i goto my second tab "Inventory" it
resets to the first record in my querry. I would like to click on the
"Inventory" tab and it be related to the "Products" tab record that i have
chosen.
More Info
I have made two seperate forms one called, "Products" and one called "Inventory". They both retrieve data from the same querry that combines the data from 3 different tables. The forms independantly work ok.What I did was made a new navigational form (horizontal tabs). I dragged and dropped of these forms to make two sepperate tabs. Now i have been told it has to do with the master/child relationship in subforms. But when you drag them into navigation they become a form for each tab. Is there a way of linking them?
