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:
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!Please Login or Register to view this content.
Entire Code Segment that is not working
Please Login or Register to view this content.
Last edited by unit285; 04-12-2017 at 12:48 PM.
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
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
If posting code please use code tags, see here.
Perfect and simple solution! Thanks!!Originally Posted by Norie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks