Help needed with a search feature on a UserForm

Hello everyone,
I hope you're all doing well. I'm currently working on implementing a search feature for my UserForm. While everything is functioning mostly as intended, I've encountered a challenge in displaying partial matches on a specific column.
The search is based on two columns selected from a combobox. For the column labeled "Denumire," the partial match is working, and the results are being displayed correctly. However, for the column labeled "IDNO," the results are only shown for an exact match, and partial matches give a "No records found".
Below the subroutine responsible for the search feature:

Please Login or Register  to view this content.

Also attached the file I'm working on.

I would greatly appreciate it if you could help me figure out what I might be doing wrong.
Thank you in advance for your assistance.

Originally Posted by Tajan

Edit: After thinking about it, my proposed solution using Autofilter:

Thank you for your input Tajan!
The solution you provided is working beautifully.
I've started exploring other methods, as you suggested earlier, but since I'm quite new to VBA, I'm not entirely sure of what I'm doing, and how everything works.

Thanks again for your help!