If Statement in VBA For Loop Not working

[unit285]

I'm trying to create a userform for generating a list of data based on parameters chosen in the userform. The code I am working on atm is below:
When I use this line everything seems to work fine:

Please Login or Register  to view this content.

But when I add another parameter like this is does not find any matches.

Please Login or Register  to view this content.

Any help is greatly appreciated!

Entire Code Segment that is not working

Please Login or Register  to view this content.

[unit285]

A good way to test is to open the Reports userform and select "CW" from the combobox and then type "Tiller" into the "Search" textbox and then click Generate Report. This searches the database for all CW and then narrows it down to Descriptions that include "Tiller" This seems to work fine. But when i enter an amount into the "Low Price" textbox it finds no matches. The Low Price textbox should narrow the matches to not include any rows of data with an adjusted cost less then the value in the Low Price textbox. Hopefully I am not confusing anyone

[Norie]

Assuming the tbLow is a textbox its value is a string so you can't use it directly in a numerical comparison.

To use the value in such a comparison you need to change it to a number and you can do that with one of VBA's conversion functions,eg Val, CInt etc

[unit285]

Assuming the tbLow is a textbox its value is a string so you can't use it directly in a numerical comparison.

To use the value in such a comparison you need to change it to a number and you can do that with one of VBA's conversion functions,eg Val, CInt etc

Perfect and simple solution! Thanks!!