Benson, William (GE Global Research, consultant)
Benson at ge.com
Sun Mar 25 19:12:19 CDT 2012
I have a combo box on a parent form. The change event of that will cause the filter of a subform on this form to turn off and then the subform is supposed to only show records which have a value in a certain field equal to what the combo box shows in its 2nd column (0-indexed). In a given example, when I reapply the filter there are no records within the subform that match that combo. So, should I be able to count on the Current event of the subform firing in such situation? It is firing when I turn the filter off, but should it also be firing when I put the filter on, though there are no matching records - or will the current event only fire if there is a record that the subform can position itself on? MySitesAndProducts.Form.Filter = "[My Sites] = '" & JetSQLFixup(Me.cboSites.Column(1)) & "'"