I have a page that lists all of the items in a MS Access table (originaltable), with a checkbox next to each one. When someone checks one of those records and then clicks submit, I want it to be copied to another table (newtable), using ASP/ SQL.
(More Details: I've been trying to use this SQL statement: "strSQL="INSERT INTO newtable(item1) SELECT item1 FROM originaltable WHERE request(rs1(record_id_numb
" and then looping so it goes through all the possible record_id_number's that could have been selected on the previous page and then passed on. But when I do that, i get the following error "Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1." which means that one of the column names (item1) does not exist (http://support.microsoft.com/kb/216425
) but i checked and double checked and it does.)