How to lookup data from a "lookup form" to a subform within another form

[Erica W]

I am trying to figure out how I can lookup data from a "lookup form" to a subform within another form.

I have one form that has an unbound field (the row source links to a table with the field to search on "Network Name") and a command button that opens another form with multiple subforms of details that I want to pertain to the search selection. The field being searched is within one of the subforms so the command button wizard doesn't work as the field isn't on the main form. What do I do to get my form to open with the data from my search selection within my "lookup form"

[Seth Schrock]

Lets see if I understand the question correctly. You have a form (Form A) that has text box that is used as the criteria for a search, the results of which are displayed in the subforms on Form B.

If this assessment is correct, then you need to create a query for each of your subforms and whichever field contains the data that would match the value in the text box on Form A would have the criteria of

[Form]![Form A]![Text box name]

This will make it so that the subforms will contain the results of the search using the text box on Form A as the criteria.

If you would provide field names, I could give a more exact query structure. Let me know if you need some clarification.