Data from Form is adding into table as 2 rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Form to add data in. It also has 2 subforms. 1 subform is going to
the same main table that the main form is going to.

My problem is that the data from the 1 subform is going into the table as a
separate row. Instead of being at the end of row with the main add info.

Does anyone know what causes this problems and how to fix it?

Thanks.

Donna
 
That's what I'd expect if you have a parent form and subform bound to the
same table. When you move from the parent form to the subform the new
record is saved to the table. When you add data to a new record in the
subform this will be saved to another new row in the table.

As you want to add data to a single new row in the table why have the
subform at all? It can all be done in the parent form. The other subform is
presumably to add data into a separate table with a many-to-one relationship
to the parent form's underlying table, in which case you do need a subform
for that.
 
Yes - Everything is correct. It's just that the data is falling into the
table on 2 separate rows.
 
Back
Top