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 - 13 May 2008 15:35 GMT
> I have two tables, Students and Events which are joined using
> referential integrity on the StuID field. I have a master form where
[quoted text clipped - 8 lines]
>
> 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