I have a main form with a subform. The main form is attached to a table called tblInvoice. The subform is attached to a table called tblInvoiceDetail. I have a button on the main form that opens a search form. The search fields include fields that are in the main form (storeno, jobno) as well as fields on the subform (itemno, description). I want to do a search on storeno as well as description. For example, search store no 180(storeno) for all brake jobs(desc) The query should reopen the main form with the results populating all fields. I can search on storeno(on main form) with no problem but when I include description(subform) I can't get it to work properly. Does anyone have any possible suggestions or possibly a website with an example? Thank you in advance.

Use the expression builder to build the criteria for your subform's recordsource.