you should see a button that says solved

did this problem get solved? if so mark it as solved so if others run into a problem then can see the solution and create another thread for a different problem

sorry about that take out the first order by srno and that should fix it

rs.Open "select srno, productname, qty, unit from mrtemp where req_no = " & strlistrequest & " order by srno", con,...

try changing the query to

rs.Open "select srno, productname, qty, unit from mrtemp order by srno where req_no=" & strlistrequest & " order by srno", con, adOpenDynamic, adLockOptimistic

is there an error number with that?

need to add & " after strlistrequest

go here. http://www.vb6.us/tutorials/formating-dates-and-times-vb6
it gives different date formats and examples