Sub Form Question

[JamesJ]

I create a form I call frmContactsSub with one field:Listing
and the default view is Continuous Form. I create another form
frmContacts based on the same table as the sub. I then drag
and drop frmContactsSub onto frmContacts.
Problem: The subform only displays 1 record and the new record.
the link child fields are the autonumber id field.
What am I doing wrong??
I've followed instructions in a book and have used the Subform/Subreport
wizard to no avail.

James

 

[Allen Browne]

Subforms are normally used to display the related record. For example, in
Northwind, the Orders form has a subform that displays records from the
related [Order Details] table. The LinkMasterFields and LinkChildFields
properties ensure that only the line items for the order are displayed.

Using a subform to display records from the same table as the main form will
give you concurrency problems, multi-user errors, and can even corrupt the
AutoNumber seed. It is NOT a good design.

If you want to do it anyway, clear the settings from both the
LinkMasterFields and LinkChildFields properties of the subform control,
since you do not want the subform to show only the record with the same
autonumber in the subform has you have in the main form.