When I enter roll no in (which is available in query) text1.text the report is generated. but when i enter another number not available in query then runtime error window appears.
I know the code to search the database and show the message.
(eg. if rs.eof then
msgbox "not available"
<next command> ..)
but what is the code to search the query so that if I enter fake no then message like "record not available" shold promt.
So will anyone help me so solve the problem.