Subforms create multiple entries in master table

[John Contact]

Hi,

First time typer long time reader. I am having a few
issues with my first attempt at using subforms. Due to the
size of the form I wished to create Access told me it
could not fit anymore controls onto the forms. So to solve
I thought I would create a subform with the remaining
controls. all seemed fine until a test was done and I
noted that when all data was enter the fields in the sub
form created an additional entry in the table, I assumed
it would update to the same entry as the master form. Am I
missing something????

 

[Denny G.]

John, typically a subform is used in a one to many
relationship, where the main form contains the "one" data
and the subform contains the "many" data. It sounds as
though you are trying to put all the "one" stuff in both
a main form and a subform. Now, if you have too many
fields (maximum is 754 in Access 2002) in your main form,
you may have a normalization/database design problem.
Get a good book on Access and learn about splitting up
your data into related tables and reduce the sizes of
your forms. Take a look at the Northwind Traders
Database that comes with your Access application and use
that as a guide.

Denny G.