Filter Further Subform Records

[Alan]

I have two tables, Students and Events which are joined using
referential integrity on the StuID field. I have a master form where
the user can choose the student to review by selecting their name in a
combo box and all their events are displayed in a subform. I want the
user to be able to further filter those subform results by limiting
them to a selected EventCode from the Events table. Is this possible?
I guess I'm asking if I can put a combo box on the subform to allow
the user to choose the EventCode he/she wants to see. I'm thinking
this "filter within a filter" may not be possible. Any help would be
appreciated.

Alan

 

[Alan]

I have two tables, Students and Events which are joined using
referential integrity on the StuID field. I have a master form where
the user can choose the student to review by selecting their name in a
combo box and all their events are displayed in a subform. I want the
user to be able to further filter those subform results by limiting
them to a selected EventCode from the Events table. Is this possible?
I guess I'm asking if I can put a combo box on the subform to allow
the user to choose the EventCode he/she wants to see. I'm thinking
this "filter within a filter" may not be possible. Any help would be
appreciated.

Alan

See Wolfgang's reply (message no. 6 in the thread entitled "Subform of
a Subform" in this same NG) where he provided the answer to this
question in connection with another of my posts.

Alan