Multiple subforms multiple records

G

Guest

I have a main form with multiple subforms. For those subforms which are
linked to the same table, when I enter data, Access puts that data into a new
record for each subform within the table. Thus, for a single individual
survey response, I end up with 4 separate records in the table, rather than
one.

How can I reconcile this? Thanks!
Karen
 
G

Guest

You'll be better off (and good DB design suggests this) if you use just one
subform for all of the fields that are linked to the same table. This will
enable you to enter all the info that will go into the table on one subform.
Create separate subforms for the other tables as well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Multiple Subforms 3
Access forms and subforms 3
new subform entry for existing record 3
Using Linked Combo Boxes with a subform 1
Subform within continuous form - workaround? 8
Subform of subform not being linked 3
All records not displaying in form 4
Use main form and subform to create single record 3

Top