[AccessD] Should Subform Current Event be firing when the filter yields no records?

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)) & "'"



More information about the AccessD mailing list