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 subform in footer with combo box in main Form
I have a combo box in a form header that filters records in the detail
section. I want that combo box to also filter a subform that is located in the footer section of the form. The subform always displays all the records, could someone help me to get the subform to filter the records by using the combo box in the header of the main form. Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
#2
|
|||
|
|||
Filter subform in footer with combo box in main Form
Add something like this to the After Update event of the combo (I assume that
is where you are filtering the main form) Me.MySubFormControl.Form.Filter = 'put the filtering criteria here Me.MySubFormControl.Form.FilterOn = True There is a bug to be aware of when filtering both the form and the subform. Go to this site http://allenbrowne.com/Access2007.html#Bugs Click on Whats Fixed In the last entry in the table (Filters), click on Filter Bugs Read item 1. "eschlep via AccessMonster.com" wrote: I have a combo box in a form header that filters records in the detail section. I want that combo box to also filter a subform that is located in the footer section of the form. The subform always displays all the records, could someone help me to get the subform to filter the records by using the combo box in the header of the main form. Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
Thread Tools | |
Display Modes | |
|
|