If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter Further Subform Records
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 |
#2
|
|||
|
|||
Filter Further Subform Records
On May 5, 8:45 am, Alan wrote:
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 |
Thread Tools | |
Display Modes | |
|
|