Specific Preview Reporting

[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.

[gatsby]

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.

WOW! you are a genius... i got it... Thanks a lot!

[gatsby]

by the way, i have another question, related also the database that was presented. this time, its a different case, should i place the question here or should i create another thread?

Thanks a lot June7!

[June7]

I suggest a new thread if the question is really very different.

[gatsby]

I suggest a new thread if the question is really very different.

okay, thanks June7.

consider this thread SOLVED. again, thanks.

[June7]

Note that Preview Report Current Wine works because code in the button click event sets filter criteria for the report.

By setting parameters in the QRY_Report as I suggested might cause that report to no longer work. If it does, maybe just fix the procedure code to not apply criteria.

[gatsby]

yes, im using the Preview Report Current Wine code for specific item (1 item only). i have 2 preview reports actually - 1 for single item and the other report is the results of the keyterm used.