Subform issues

[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????

any Help much appreciated

 

[Graham Mandeno]

Hi John

Use the LinkMasterFields and LinkChildFields properties of your subform
control to synchronise the subform with the main form.

Set LinkMasterFields to the name of a *control* on your main form which is
bound to the primary key field.

Set LinkChildFields to the name of the primary key field (which must also be
included in your subform's recordsource).