Print report from results of Search

[RonNCmale]

Need a way to print my results from my search box to a report. The following attachment prints all and not just the searched results. Any help will be appreciated.

[OBP]

Have you password protected your Zip file?
What type of search are you doing?
On Form with a filter or using a Query?

[RonNCmale]

No password on zip, The search is using VBA code.

[OBP]

I can't unzip your database, the Zip file for some reason asks for a password.
I know this is primarily a VBA Forum, but why use VBA to search when Queries do it so easily, the results of which can be passed to a form or Report?

[RonNCmale]

I'll do the query search then. Thanks anyway.