Filtering a Subform with text box on main form

[Lori2836 via AccessMonster.com]

I want to create a unbound text box (txtPartNum) on my main form (ECRs to be
reviewed) and have the subform (Get Open ECRs) filter as the part number is
being typed into the text box. I've read a ton of info here, but I'm not
sure exactly the right way to do it. Can the main form be unbound or does
it need to have a record source?

Thanks for any help on this!

Lori

 

[Jeanette Cunningham]

Hi Lori2836,
download the sample search form from
http://allenbrowne.com/ser-62.html

the textbox for Name is unbound and shows how to filter the form using what
the user types in the textbox.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Lori2836 via AccessMonster.com]

Thanks Jeanette - I'll give it a try!

Hi Lori2836,
download the sample search form from
http://allenbrowne.com/ser-62.html

the textbox for Name is unbound and shows how to filter the form using what
the user types in the textbox.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

I want to create a unbound text box (txtPartNum) on my main form (ECRs to
be

[quoted text clipped - 8 lines]

Lori