Filtering records in a linked subform

[bv]

Hello,
My database is used to maintain contact information for distributing
materials. On one form, the user selects the distribution group (main form)
and then sees all the contacts who are in that group (subform). The
contacts displayed on the subform are identified as primary or not using a
yes/no field. When choosing the distribution group, the user currently sees
all contacts on the list. I would like to use a button to allow the user to
view primary contacts only, however, I can't get this to work using filters
when the main form is open. I can apply the filter successfully when the
subform is opened individually, but it does not work from the main form.

Is it possible to apply the "Primary" = yes filter to the subform and
maintain the master/child link with the main form when the main form is
open?

Thanks for any suggestions!
Beth

 

[Guest]

Hi

Base your subform on a query and place the filter in the criteria row of the
column with the yes/no data

 

[Larry Linson]

Can I suggest that you might have better luck simply replacing the
RecordSource of the Form embedded in the Subform Control, using criteria to
select whether you want Primary = True?

Perhaps it's only due to my not fully understanding "filters", but filters
have always seemed "quirky" to me, and I note that I am not alone in that
view.

Larry Linson
Microsoft Access MVP