adding record and updating record count

<i><b>Originally posted by : Jason (jslambert@aimlighting.com)</b></i><br />I'm using the following code to display the contents of a series of fields used to update a database. THe problem is that when someone adds a record to the database, the count, in this case 6, doesn't increase by one. If the actual number of records in the database and that count number get off, the update doesn't work. How do I make that number (6 in this case) automatically increase, OR what code can I use to it's not important that that number matches what's in the database. Thanks for your help.<br /><br />set conn = server.createobject("adodb.connection")<br />conn.open strconn<br />set rs = server.createobject("adodb.recordset")<br />rs.open "tblUpdateADO", conn, 2, 2<br />rs.movefirst<br />for x = 1 to 6<br />rs("Quote") = request("Quote" & x) <br />rs("Author") = request("Author" & x)<br />rs("Display") = request("Display" & x)<br />rs.update<br />rs.movenext<br />Next<br />rs.movefirst<br />%>

???
Must be s.th. like

For X = 1 To rs.RecordCount

or so...