Subform doesn't appear to be linked

[Jen]

Hello. I have a subform that is linked to the main form by
an account number field. The subform is based on a query
and shows all the data in the query, it doesn't just show
the data for that account number on the main form. I'm
using Access 97. I can't figure out why it is not working
and I've decided that I can't stand subforms. What is the
big mystery with these?

Thanks,
Jen

 

[Gary Miller]

Jen,

Look in the properties of the subform control that holds your subform and
check the LinkMasterFields and LinkChildFields lines in the data section. If
they are empty, that is where your problem lays. These need to be set to the
primary / foreign keys of the underlying tables, usually the primary ID of
the master table so that it can find that ID in the child table.

Once you get the hang of them, subforms are great!

Gary Miller