Forms\SubForms

[CanoeTrail]

I have a form with one subform, both of which seem to work
OK. Using Northwind example, the subform {Order Details}
is many and the form {Orders} is one. The subform {Order
Details} get lots of its data from another table
{Products} which is one to the subform {Order Details}
many. It looks just like the Northwind example and the
data goes in great.

I only enter a maximum of three products on the subform.
However, when I enter a second record on the subform the
number of main forms increases by one (I get one more main
form in my database).

How do I keep the number of main forms from incrementing
by one every time I enter more than one record on my
subform?

Thanks

 

[Rick Brandt]

I have a form with one subform, both of which seem to work
OK. Using Northwind example, the subform {Order Details}
is many and the form {Orders} is one. The subform {Order
Details} get lots of its data from another table
{Products} which is one to the subform {Order Details}
many. It looks just like the Northwind example and the
data goes in great.

I only enter a maximum of three products on the subform.
However, when I enter a second record on the subform the
number of main forms increases by one (I get one more main
form in my database).

How do I keep the number of main forms from incrementing
by one every time I enter more than one record on my
subform?

The subform should be bound to the Order Details table, not a query that
includes both the Order Details and the Orders table. Is that how you have
it set up?

 

[Guest]

Rick
Thanks for prompt response, Have to leave for 4 hours,
will check out your suggestion on return.
CanotTrail