connecting the subform to the form and subform layout

[Guest]

2 problems:
1. I have an Address table that has a one to many relationship with a Names
table (so multiple names have the same address) They are connected by the
primary address id key.

In the data entry form, I created a subform to display the individual's
information for that address. But the subform is displaying all the records
in the table, not just the ones associated with the current address id for
the form.

So how do I set the subform to display data related to the designated
address on the main form?

Thanks, Amanda

 

[Guest]

Hi Amanda,

If I understand your question, you are trying to display the correct record
in the Address table associated with the client's AddressID. If your client
information is on the main form and the Address is in a subform, then:

1) in design mode click on the subform
2) open subform's properties
3) find properties "Link child fields" and "Link master fields" and type
AddressID in both (or whatever the exact name is of the linking field).

That should resolve it.

 

[Guest]

Sam,

Thanks so much for the help! Actually the link fields were set correctly,
but when I tried to modify them, I got an error that the "missing pair would
be ignored". Looking into this further, I found that the recordset for the
subform did not include the linked field (AddressID). Once this was
corrected, the subform worked appropriately. Thanks again!

- Amanda