When paging through a record set we use a SQL statement with a WHERE clause that&#039s followed by a &#039"& request("variable") &"&#039 or a variable with a SQL string in it EX:<BR><BR>lstCategory = "Category = &#039"& lstCategory &"&#039"<BR><BR>so after the WHERE clause the SQL would read <BR><BR>SqlStmt = SqlStmt & " " & lstCategory & " ". <BR><BR>The first page comes back correct, but if you press NEXT, it errors. It doesn&#039t process the rest of the SQL statement after WHERE.<BR><BR>Any Suggestions?<BR><BR>Thank You,<BR>TBrooks<BR>