I'm using Access 2003 and reviving some development on an application.
I have an Orders form with a Products subform. 1:n relation****p between
tables.
Is there any way to programmatically set a Filter on the Products subform
and
have it result in a filtering of the Orders form? The forms are bound and
Master/child key binding set in code.
So far I have been able to filter the subform (Products) but the result is
that the main Orders form displays blank product records (in the subform)
for
those records that are filtered out (instead of filtering out both subform
and form records).
I know that it works the other way (filter main form, subform gets
filtered)
but I was hoping that there is some way to go "in reverse."
Thanks for any suggestions.
