Subforms generating multiple duplcates in main table

R

rblivewire

I have three separate subforms on my main form connecting by a
automatically generated number. As a user enters info into each of
these subforms, a new line item is created in a main table. This means
for 1 form, 4 line items are generated in teh main table. Is there any
way around this problem?
 
J

Jeff Boyce

What is your underlying data structure? The data is stored in tables, and
displayed in forms.

A common way of using main form/subform is to have the "parent" record/table
reflected in the main form and the "child" record/table reflected in the
subform. How are you able to get a subform record accepted before there's a
parent/main form record for it to relate to?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Top