check all thye batchnos in Access table and display corresponding information in sheet1.

Hi All

Please see attached the workbook. There is a userform where you have to enter the batchno in the textbox . and then VBA code will check the Access database for all the batchno which are <= textbox1.value.

And then in Sheet1 , column A contains all the batchnos. We have to check if all those batchnos exist in the sheet1. if yes then display cases,pages and policy no to the corresponding batch numbers found.

I have written the code but it doesn't work. I hope anyoone make the changes accordingly.

Thanks