>I have checked this. and set it as you have suggested.
>
> Yet some of the fields in my main form are not being populated. Why
> might this be?
>
> For example:
>
> My main form uses table A:
> Fields include:
> Postcode
> Group Ref1
> Group Ref2
>
> When I filter for a postcode the latter two fields do not lick up info
> from the table.
>
> Running the filter on the main form should prompt the subform to
> display:
> All the records found in Table B with that particular postcode.
>
>
> Arvin Meyer [MVP] wrote:
>> If the subform and mainform Link Fields are set to the post code field,
>> that
>> will be automatic.
>>
>> Look on the form's property sheet. Select the subform, in Design View,
>> open
>> the property sheet, click on the Data tab, and match the fields from each
>> form in the Link Master and Link Child properties.
>> --
>> Arvin Meyer, MCP, MVP
>> Free MS-Access downloads:
>>
http://www.datastrat.com>>
http://www.mvps.org/access>>
http://www.accessmvp.com>>
>> <nicolasmith12[ at ]hotmail.com> wrote in message
>> news:1159529120.655164.237540[ at ]e3g2000cwe.googlegroups.com...
>> >
>> > I'm new to Forms and Sub Forms, so I could do with some help. I have 2
>> > tables A and B, both have multiple fields, but both tables have a
>> > Postcode field.
>> >
>> > Table A has one record per postcode
>> > Table B has Multiple entries per postcode.
>> >
>> > I need to set up a main form based on table A that can be filtered
>> > based upon postcode. When a user filters for a particular postcode, as
>> > well aspopulating the fields in the main form; I would like the
>> > sub-form in turn to return all entries in Table B for that same
>> > postcode.
>> >
>> > Is this possible? I hope I have explained my problem clearly.
>> >
>> > All feedback gratefully recieved.
>> >
>> >
>> > Thanks
>> >
>