Hello,
I have several subforms on a form. Each subform is filtered by an individual row in a listbox located on the form. A VB procedure enables the user to make changes to listbox's rowsource and subsequently change the way the records in it appear. When this happens both the records in the listbox are sorted and the subforms' filters are changed. While this may sound strange, it works well for its intended purpose. My only problem is that, when I initially open my form, the subforms will not filter at all. I have to re-enter design view and then re-open the form for the subforms to filter the way the should. Once re-opened the subforms filter like they're supposed to.
Can someone clue me into why these subforms will not filter upon initial opening? Please let me know what I'm missing here or I need to elaborate further. Thanks
I have several subforms on a form. Each subform is filtered by an individual row in a listbox located on the form. A VB procedure enables the user to make changes to listbox's rowsource and subsequently change the way the records in it appear. When this happens both the records in the listbox are sorted and the subforms' filters are changed. While this may sound strange, it works well for its intended purpose. My only problem is that, when I initially open my form, the subforms will not filter at all. I have to re-enter design view and then re-open the form for the subforms to filter the way the should. Once re-opened the subforms filter like they're supposed to.
Can someone clue me into why these subforms will not filter upon initial opening? Please let me know what I'm missing here or I need to elaborate further. Thanks