Subform issues

  • Thread starter Thread starter John Contact
  • Start date Start date
J

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
 
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).
 
Back
Top