What I really meant was entering different values for specific records. For example, if someone has ordered an apple and an orange I need to take 1 from the stock column for apples and oranges. The way I have the information displayed on the page is a table showing the customer's order. In the table, the product name, number ordered, and updated stock numbers are displayed. I have looped through the recordset so that each item within the customer's order has been displayed. I want to be able to hit one submit button and have each record updated with the new stock level. Help...please! Matt At 18:09 31/10/02 +0300, you wrote: >using the UPDATE sql statement yu can update multiple records. >for eg. > >Update authors >Set name = "gorilla" > >this statement will update all author names to "gorilla" > >Look up the keyword UPDATE in the acces manual... > >------ >Ashok Hariharan >http://www.unganisha.org >------ > > > >-- >For unsubscribe and other options, including >the Tip Harvester and archive of thelist go to: >http://lists.evolt.org Workers of the Web, evolt !