Paging results error please help!

[Vlince]

************************************************** *************<BR>********I have a textbox in a form on my page1.asp:************<BR>************************************************** *************<BR><FORM><BR><INPUT id=txtBaniere name=txtBaniere><BR><input type="submit" value="OK" name="sub"><BR></FORM><BR><BR>************************************************** **************<BR>In my page2.asp I connect to my database and retreive the value of the textbox:<BR>************************************************** **************<BR>Dim varBaniere<BR>varBaniere = Trim(Request("txtBaniere"))<BR><BR>***********Connection*************<BR>Set conn = Server.CreateObject("ADODB.Connection")<BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR>conn.Open "dsnname"<BR><BR>****************Query*****************<BR>strSql = "SELECT Banniere.Ban_Definnition, Client.Num_Client, Client.Adresse1, Client.Num_Tel, Client.Num_Fax, Client.Nom_Legal, Demande.Num_Demande " & _<BR>" FROM (Banniere INNER JOIN Client ON Banniere.Cd_Banniere = Client.Cd_Baniere) INNER JOIN Demande ON Client.Num_Client = Demande.Num_Client WHERE "<BR><BR>If varBaniere <> "" Then<BR>strSql = strSql + "Banniere.Ban_Definnition LIKE '" + varBaniere + "%'"<BR>End if <BR><BR>rs.Open strSql, conn,adOpenForwardOnly ,adLockReadOnly <BR>************************************************** ***************<BR>Now if I enter the letter: j<BR>the query works find and i get all the information i wanted, since i've decided that i only want to show 10 records per page. I have a "next" and "previous" button. (I didn't put the code of the paging in this example because it's too long but trust me i've set it to 10 records/page)<BR><BR>Now when i do a response.write of my strSql statement I get:<BR>SELECT... WHERE Banniere.Ban_Definnition LIKE 'j%'<BR><BR>Then I have a "next" button that apears since this query returns more than 10 records!<BR>The problem occurs when i click on that button i get an error message. The error message is:<BR>Microsoft OLE DB Provider for ODBC Drivers error ' 80040e14' <BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error in WHERE clause. <BR>/Vlince/page2.asp line 53 <BR><BR>And the line 53 is:<BR>rs.Open strSql, conn,adOpenForwardOnly ,adLockReadOnly <BR><BR>The response.write of my query is:<BR>SELECT...WHERE<BR><BR>So the problem is when i click on the "Next" button it seems to me that the query looses the WHERE clause but why??? can you please help me!<BR>Thanks<BR><BR><BR>