Display records from search in subform

[Guest]

I'm trying to create a main form from which I can type a
part number into a textbox and then display the results of
the search in a subform after clicking a button. Can
someone guide me in the steps to do this?

Thanks a bunch!

 

[Allen Browne]

Does the main form have its own records, or is it just a holder for the
subform?

If it is just a holder, open it in design view, right-click the subform
control, choose Properties, and enter the name of the textbox into the
LinkMasterFields property. Enter the name of the matching field from the
subform into the LinkChildFields property. No code. That's it.

If the main form has its own records, see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html