Search subform?

  • Thread starter Thread starter richard.iserman
  • Start date Start date
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.
 
Richard

I'm confused. If the data is related one-to-one, and if both main form and
subform are based on the identical query, why bother with a subform? What
are you trying to accomplish by using this design?

More info, please...

Jeff Boyce
Microsoft Office/Access MVP
 
Good point.
It's actually a whole bunch of subforms, which I'm using to save visual
space on the main form. They're all on top of each other, and only
made visible by selecting from an option group. I know this is pretty
common, but I also see how it's a bit unusual to have the subforms
pulling from the exact same query as the main form.
For my purposes, it's just a matter of saving space.
 
Aha! If screen space is an issue, but you have tightly-related and 1-many
related data to somehow keep closely associated, take a look at a tab
control. You can put a sub-form one per tab, and the 1-1 data you described
on a tab of its own.

Regards

Jeff Boyce
Microsoft Office/Access MVP

.... just another person's opinion ...
 
Back
Top