I have tried the code for not display any record as default
if Request.Form="" then
strSQL="select * from "strTableName & "where 1=0"
itself works fine, but the page lost the paging on the bottom, if I deleted the code being added, I can get full records displayed but the paging on the bottom did not come back. Did I get something wrong?