It's like this. Let's say you have an Inventory Master table (Item#, Item Descrip, cost, price, and unit of measure) and a Inventory History Table(Item#, date, type of activity, and quantity), and an Inventory Warehouse table (Item#, warehouse number, units on hand)
Make 3 forms, one for each of those tables. The Inventory Master form will be a single form view (one item at a time), and the other two forms will be continuous view. Put the text boxes for the Inventory Master form in the heading of that form. The detail will start out empty.
Don't bother to put Item number on the two other forms, and put all the other fields in the detail area of these forms. Don't bother with heading and footer on those forms until you're an old hand at this type of forms-within-a-form form.
The Inventory history and warehouse forms will have many different items shown at the same time, because they're continuous forms and you're not asking for an item number. You've simply specified the table or query they're bound to, so the data for many rows appears there.
Now, on the Master form, add your tabs to the detail area. Name one tab History, and one tab Warehouse. Then, drag the History form to the History tab (in Design View of course) and drag the Warehouse form to the Warehouse tab.
You will have to set up the parent/child linkage (parent will be Item Number in the Master file and child will be Item number in the History or Warehouse files).
The Master data appears in the heading of your Master form. No need for any of that table's data to appear in the tabbed sub-forms. The History table data appears on the History tab, and since you have linked it by Item number, you will see only the data for one Item (the same Item you selected in the Heading area). Ditto the Warehouse tab ... if you have 3 warehouses with on hand for that item, you'll have 3 rows appearing in the Warehouse tab.
Get the 3 forms works independently, then move the 2 subforms to the correct tab area on the Master form. You'll be amazed at how simple it is when you see it work.
Good luck.
Jim
Hi Jim
Thanks for the suggestion. I am having a few problems getting it to work - such as how do I get the 'master form' to display on each tab - this will contain the heading information 9in you case I suspect part details) for all the tabs.
Cheers