filtering a recordset in a subform

[Deborah]

I have a recordset in the main form. I have several
subforms on this main form (all at the same level) I need
to filter (or do a find) so that a particular recordset
goes to a particular subform. However, there doesn't seem
to be an event within the subform that gets seen. The
linking field between the subform and main form changes
appropriately but any event based in the subform doesn't
work. Anyone have any ideas?

Deborah

 

[MacDermott]

Perhaps you could explain your problem in a little more detail?
With examples?

- Turtle

 

[Guest]

Basically what is going on is there is a document being
worked on by several people, each of whom has a specific
role. The main form has a combo box with the different
document names. Each role has a different subform with the
role as the default value. All the subforms are on the
main form at the same level. When a document is chosen
from the main form a recordset is gotten. What I want to
do is use the main form's recordset, get each subform to
filter (or find) based on its particular role and thus pop
up the person doing that role into that subform's textbox
(I have a different way of putting people in originally)
Basically I am trying to get one row for each subform. So
far, however, I can't find a way to make the
subform "notice" that the document has been changed and
get the filtered recordset. It's a team tracking thing.