Filtering the choices in a subform datasheet

  • Thread starter Thread starter Steve Finlayson
  • Start date Start date
S

Steve Finlayson

Hi all. I have really not been able to solve this and could use any help.

I have two tables A and C that are linked with a one to many relationship to a
center table B: A < B > C. I then have created a query to provide the link
between the many to many relationship of the two outer tables so they will
update A and C. Using this query as the basis for a form, I have a datasheet sub
form that shows all the records in the table C. The subform is linked child to
master using one field, say field 1. On the parent form is also field 2. When
selecting a record to show in the datasheet in the subform, the records relating
to ALL field 2 entries are shown. I would like to filter this so only the
possible records shown are those matching the chosen value in the field 2 on the
master form.

Thanks for any suggestions or ideas

Steve
 
It SOUNDS like you want to use the subform to filter the
Master form. That's not how you want to do it.

Several possibilities:

1) You may have to use a different query to feed the
subform and/or Master form.

2) Change your join types.

3) Change the subform query so that its Unique Records
property is set to Yes.
 
Back
Top