Filter form recordset

[Chris]

I am getting back to access after a while. I am using 2003. I am trying to
filter a subforms recordset based off another subforms recordset. Basically,
i have one big form, and then I have 3 subforms on it. One subform 1, I have
continuous forms listing of my work centers. I want to click on a particular
workcenter, and have subform 2 only display the names of people assigned to
that workcenter. Then, i want to click on the person in subform 2 and have
subform 3 pull up that specifics person info. Additionally, and i am not
sure if this is possible, when i click on the work centers on subform 1, and
filter the list on subform 2, i would like subform 3 to filter its recordset
as well, since that is where i do my input of info. Obviously, i have the
names field and workcenter fields on all applicable forms, whether visible or
not. Any help on this would be great, thanks.

 

[Marshall Barton]

I am getting back to access after a while. I am using 2003. I am trying to
filter a subforms recordset based off another subforms recordset. Basically,
i have one big form, and then I have 3 subforms on it. One subform 1, I have
continuous forms listing of my work centers. I want to click on a particular
workcenter, and have subform 2 only display the names of people assigned to
that workcenter. Then, i want to click on the person in subform 2 and have
subform 3 pull up that specifics person info. Additionally, and i am not
sure if this is possible, when i click on the work centers on subform 1, and
filter the list on subform 2, i would like subform 3 to filter its recordset
as well, since that is where i do my input of info. Obviously, i have the
names field and workcenter fields on all applicable forms, whether visible or
not.

The standard way to filter one subform to match a record in
another subform is to use the Link Master/Child properties
on the second subform control.

Use a hidden main form text box (named txtLinkWC) as the
Link Master. Set the text box's value in the first
subform's Current event:
Parent.txtLinkWC = Me.thelinkingfield