Subforms generating multiple duplcates in main table

  • Thread starter Thread starter rblivewire
  • Start date Start date
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?
 
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/
 
Back
Top