Automatically filtering sub form by linking it to main form primary key

[tikkat3]

Is it possible to automatically filter a sub form using the main form's primary key as the filtering criteria?

I have a simple 3 column sub form, which displays the results of a query. The middle column is a list of client reference numbers, which are also the same as the primary keys.

The sub form is simply there to display data and is not linked into any other tables of my database. Its parent is a linked table that is updated independently, hence it is a display only sub form.

There is a lot of data in the sub form. Ideally I would like it to show: if the main form's primary key is "WOO" then the sub form will be filtered so that the data that has "WOO" associated with it will be displayed.

Any help or thoughts are much appreciated!!!

 

[MStef]

Link Main form and Subform via LINK CHILD FIELDS and LINK MASTER FIELDS properties (in Main form).

 

[tikkat3]

Thanks I will give it a go - might be beyond my basic knowledge of Access, so might come back for more advice!