[pinochio53]

I have a repeating table that has a form in it, and i want the values from the table to be inserted into an access table. here is a screenshot http://www.goofu.net/screen.jpg

I want it so that when you put in an amount it will add just that line to the database with the amount. they way i have it now it tries to add every single value from the whole table into the database, does anyone know how i can make it be restricted to just one line. i want it to only put that one line into the database.

below is the error i get when i try to do this.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
/parts_db/project4/partpick.asp, line 115


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)

Page:
POST 16088 bytes to /parts_db/project4/partpick.asp

POST Data:
Inventory=ACTV1635&Description=RECEIVER%2C+OPTICAL +-+590812&PartNo=590812&Price=1597.67&amount=25&Requ est+ID=&Submit=Add&Inventory=ACTV8201&Description= TRANSMITTER%2CSGL+ISOLATED+UNCOOLED+DI STR+FEEDBA . . .

to do that, in the repeated section (before and after the <tr> </tr> tags) add the form tags

Code:

  <form>
  <tr>
  row 1
  </tr>
  </form>
   <form>
   <tr>
   row 2
   </tr>
   </form>
  ---
  
   <form>
   <tr>
   last row
   </tr>
   </form>

thats what it should look like when out puted

Code:

 <% do while not rs.eof %>
 <form action="add.asp">
 <tr>
 <td><%=rs("info1")%></td>
 <td><%=rs("info2")%></td>
 <td><%=rs("info3")%></td>
 </tr>
 </form>
 <%
   rs.movenext
   loop
 %>

actual code needed

that should solve your problem, just make sure you set the form action and other necessary properties