Im looking for some code to handle the event where a search string returns a null ie "select * from table where pno=1" when there are no occurences of pno=1.
im guessing it will look something like this only more complex,
if resultset1 = null then
msgbox("No record found")
the correct code would be highly appreciated