I have two subforms on one main form. They are both controls of the same main
form. Neither is a subform of the other, and they are not linked. Nor are
they linked to the main form. This arrangement is to allow simultaneous
viewing using a continuous form for form 1 and datasheet view for form 2.
While in form 1 I would like to modify and apply a filter to form 2 and have
the new, filtered data immediately appear. I need to use the OnCurrent event
of form 1 because the form 2 filter can change based on a field value in form
1.
I suspect my problem has been in coming up with the correct syntax for
refering to the second form.
I would appreciate any suggestions.