hi
i have a table called LIST with the the following columns, ID, NAME, DEPT. other than ID which is the primary key, the other 2 columns accept null values

now i have a form which displays all the records from LIST in the respective fields, i.e. ID column in txtfieldID, NAME in txtfieldNAME etc. is there anyway i can update all the records shown after submitting the form? updating a single record is fine, but when it comes to multiple records, the values in request("txtfieldID") etc will be in array

how do i go about constructing my statement to update multiple records?

btw. i am using access at home and sql at the office, incase there is a difference in the way to construct the abovementioned statement

You will need to update each record independantly, especially if you are using Access. The trick is to name each form field differently (but according to a pattern), which then allows you to get the relevant data for each record on the next page. There is some sample code here (but the download link doesn't work):
http://www.adopenstatic.com/resource...plerecords.asp

If you are using SQL Server, then you can use a Command object (instead of inline SQL), and assign the values of the various fields to parameter objects, but the basic principle is the same.

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com

thanks for your help
now i know how to go about updating multiple records