Access 2003 - Forms & Sub Foms

  • Thread starter Thread starter nicolasmith12
  • Start date Start date
N

nicolasmith12

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
 
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.
 
Back
Top