ok

1. this userform is one of many,
2. This userform works from a "Welcome userform" contains many of userforms like that
3. when you opend that userform from welcome, and put any number (1-999) in that yellow field, it searched the entered number in database, and if found, it gets all items explained below in userform
4. If the code doesn't find the number, there's a msg error "There are no results for your search criteria, please try again"
5. I know that the code will runs with you, he almost did that with me, but sometimes the code jump to this msg although the searched number exists

I hope the problem comes clear