"Find" in subform (Access 2007)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform on a main form (created from tables with 1:N relationship).
I need to be able to "find" a record in a subform and have that record and
it's parent record show. Documentation in Access Help says that you can only
use "find" in the parent form. Has anyone found a way to work around this?
 
Nope. The only records available to search in the subform are the ones that
are related to the main form.
You can add an unbound comb box on the main form to do searching using a
query with both tables joined. Have the combobox display both the main and
sub information. Once you find the item then search the main form.
 
Thanks Karl. I am trying to make your suggestion work. So far I am not doing
so good, but I will figure it out. Like you say: Build a little - Test a
little :)
 
Is there a way to 'goto' the main record when you select the one you want in
the combo box?
 
Back
Top