"Find" in subform (Access 2007)

[lighthouse118]

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?

 

[KARL DEWEY]

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.

 

[lighthouse118]

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

 

[pcbins]

Is there a way to 'goto' the main record when you select the one you want in
the combo box?

 

[Allen Browne]

Is there a way to 'goto' the main record when you select the one you
want in the combo box?

Assuming the combo is unbound, see:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html