Form Display

[skk]

Hi All,

I have 2 tabs (Order and Parts) in my form. I have it set up as a 1 order
with many parts relationship. When I fill out the info in my order tab (1
entry) and then click on my parts tab and place many entries (8 entry), and
then I go back to my Order tab, I find that i have 8 entries that are all the
same. If I place a second order with 8 more parts then I get 16 orders
displayed but only 2 of them are diff. How can I display only one Order
under my order tab with multiple parts and then when I go to the next order
(order 2) without displaying duplicate Orders

Thanks for any help!

 

[Rob Parker]

You need to put a subform, bound to the Parts table, onto the parts tab, and
link it to the main form (probably via an OrderID field).

A tab control does not automatically function as a subform(s); it is merely
a convenient way of displaying more information than will fit into a single
form page. Every page of the tab control is bound to the form's recordset -
unless you put a subform onto the tab page.

HTH,

Rob