thread702-1584791
Well I knew it had been a while since I had been here, so I wasn't surprised to see the post cosed. Health issues have kept me from developing this as I had hoped.
I encountered an error with the subCategory field in the filter initially but I had figured this may have been because I hadn't actually added in the final category and sub category values for all the items.
When I select a category, the appropriate choices appear in the sub category drop down. However, once a selection is made the following message box pops up:
Run-Time Error '3464' Data Type Mismatch In Criteria Expression
To be sure I hadn't screwed anything up, I downloaded the last working version from the previous post and it worked OK. I then linked to the tables with the most recent data and the error exists. I am unsure where to begin to look and would appreciate any suggestions.
Well I knew it had been a while since I had been here, so I wasn't surprised to see the post cosed. Health issues have kept me from developing this as I had hoped.
I encountered an error with the subCategory field in the filter initially but I had figured this may have been because I hadn't actually added in the final category and sub category values for all the items.
When I select a category, the appropriate choices appear in the sub category drop down. However, once a selection is made the following message box pops up:
Run-Time Error '3464' Data Type Mismatch In Criteria Expression
To be sure I hadn't screwed anything up, I downloaded the last working version from the previous post and it worked OK. I then linked to the tables with the most recent data and the error exists. I am unsure where to begin to look and would appreciate any suggestions.