
Originally Posted by
June7
Okay, the form works.
The RecordSource for the report has no filter criteria.
The listbox returns all records that have the search value in any field of the RowSource query. This is accomplished by applying the filter criteria to every field in the query on different OR row for each field. Look at the design of QRY_SearchAll. Do the same for QRY_Report. Criteria under each field and on a different OR row for each field (stair-step effect): LIKE "*" & Forms!FRM_SearchMulti!SearchFor & "*"
Or use the QRY_SearchAll for both form and report.