form, subform

  • Thread starter Thread starter Kevin Sprinkel
  • Start date Start date
K

Kevin Sprinkel

If your subform is linked to the main form (via the Link
Master Field and Link Child Field properties of the
subform control), then if you are positioned on a new row
on the main form, no detail records will be associated
with it, therefore none will display. If you're seeing
any, you most likely have not linked the subform to the
main form properly.

Open the main form in design view, show the properties
(View, Properties), click on the ellipsis to the right of
the Link Master Field property, and set both properties to
the primary key of the main form recordset and the foreign
key matching it in the subform, respectively.

HTH
Kevin Sprinkel
 
Subform is empty but it allows me to enter data before anything is put
in new row of the main form. That's the problem.
alekm
 
I have a similar problem except the opposite. My main form
will not allow me to enter a new record. I think that is
because both of the forms are based on the same employees
table: the main form shows supervisors and the subform
shows subordinates, so the emplowees field is self-linked
on the "reports-to" field.

Still, if I can enter in the subform, why not the main
form?
 
Back
Top