filtering a subform

[Guest]

Hi all
I have a mainform with Familyid field and a subform with familyid field, the
subform record source is a query, the master and child links are set to
familyid which works fine.
i have an unbound option group in main form with active and nonActive options.
now what i want to do is to filter the subform and show only records where
either active = 0 or active =-1 depending on the option group at main form as
this family could have both active and nonActive members.

any help is appreciated.

thank you

 

[Steve Schapel]

K. Shoghi,

Just add a Criteria to the Active field in the query that the subform is
based on, using syntax such as...
[Forms]![NameOfMainForm]![NameOfOptionGroup]
You will need to change the Option Value property of the 2 Option
Buttons in the Option Group to 0 and -1 (probably they will have been
set to 1 and 2 by default).

 

[Guest]

excelent

it did the job, thank you very much

K. Shoghi,

Just add a Criteria to the Active field in the query that the subform is
based on, using syntax such as...
[Forms]![NameOfMainForm]![NameOfOptionGroup]
You will need to change the Option Value property of the 2 Option
Buttons in the Option Group to 0 and -1 (probably they will have been
set to 1 and 2 by default).

--
Steve Schapel, Microsoft Access MVP

Hi all
I have a mainform with Familyid field and a subform with familyid field, the
subform record source is a query, the master and child links are set to
familyid which works fine.
i have an unbound option group in main form with active and nonActive options.
now what i want to do is to filter the subform and show only records where
either active = 0 or active =-1 depending on the option group at main form as
this family could have both active and nonActive members.

any help is appreciated.

thank you