R
richard.iserman
I've found several threads that deal with issues that are similar to
this, but none quite answer my problem.
I have a subform set up to display information that corresponds to
information on the main form on a one-to-one basis (subform is linked
to the main form by record ID).
Unfortunately, this means that while I can search for a record within
any of the fields on the main form, I can't do this in the subform
because it's always limited to showing just the record displayed in the
main form.
Is there a way to make the form and subform dependent on each other,
such that I could search within a field in the subform and have the
corresponding record in the main form show up, and vice versa? Both
form and subform are drawing from the same query.
this, but none quite answer my problem.
I have a subform set up to display information that corresponds to
information on the main form on a one-to-one basis (subform is linked
to the main form by record ID).
Unfortunately, this means that while I can search for a record within
any of the fields on the main form, I can't do this in the subform
because it's always limited to showing just the record displayed in the
main form.
Is there a way to make the form and subform dependent on each other,
such that I could search within a field in the subform and have the
corresponding record in the main form show up, and vice versa? Both
form and subform are drawing from the same query.