Parent Form Displaying Once Per Record In Child Form.

  • Thread starter Thread starter MDW
  • Start date Start date
M

MDW

I've got a basic form/subform setup. The linking of the
two forms works ok. However, the parent form is appearing
once for each record in the child form.

For instance.... I've got record navigator buttons on the
parent form. If the child form has three records in it,
then I have to click the "Next" button three times before
the parent form switches to the next record.

I fixed this once before, but I forget how.
 
I've got a basic form/subform setup. The linking of the
two forms works ok. However, the parent form is appearing
once for each record in the child form.

For instance.... I've got record navigator buttons on the
parent form. If the child form has three records in it,
then I have to click the "Next" button three times before
the parent form switches to the next record.

I fixed this once before, but I forget how.
Click to expand...

It would appear that you have based the mainform on a Query joining
the two tables. The mainform should be based on the "one" table, the
subform on the "many" table.
 
-----Original Message-----


It would appear that you have based the mainform on a Query joining
the two tables. The mainform should be based on the "one" table, the
subform on the "many" table.


.
Click to expand...

Oooooh....right right right. I tweaked the record source
for the main form - worked like a charm.

Thanks!
 
Back
Top