I have a form with a subform. The 2 are not related based on the primary key
of the parent form. From the main form, I have a combobox who's event calls a
public subroutine in the subform... and that subroutine sets the subform
filter.

Works beautifully !

The subform dutifully displays appropriate records as I change the selection
in the combobox.

The problem is that if I click anywhere on the subform, things go haywire. If
I now change the combobox again (after having clicked in the subform), NO


RECORDS get displayed in the subform unless I select the same selection it
was at when I clicked in the subform.

I tried to use me.recordsource instead of me.filter… and again, it worked
beautifully until I click anywhere in the subform.

I tried setting the Allow Edits in the subform to False, thinking this had
something to do with the fact that the form was “dirty” but that made no
difference.

Anyone have any clues????

Thanks
-Ed