I have a recordset that will display various accounts and their status. The
status is yes or no, which is reflected on a webpage in the form of a
checkbox. If the status is yes, the box is checked. If the status is no, the
box is unchecked. What I want to be able to do is check or uncheck any of
the displayed boxes, and press an update button. From there, the table
holding the status value should be changed for each displayed record. Is
there a way to do this?

Any help is greatly appreciated.

--Ashley

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Young, Ashley" <Ashley.Young@c...>
Subject: [access_asp] Updating Multiple Records


: I have a recordset that will display various accounts and their status.
The
: status is yes or no, which is reflected on a webpage in the form of a
: checkbox. If the status is yes, the box is checked. If the status is no,
the
: box is unchecked. What I want to be able to do is check or uncheck any of
: the displayed boxes, and press an update button. From there, the table
: holding the status value should be changed for each displayed record. Is
: there a way to do this?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Yes. What you want to do is relatively simple.

The following:
http://www.adopenstatic.com/resources/code/updatemultiplerecords.asp
does more than what you want. Take the idea and cut out the bits you don't
need. (PS the download doesn't work as it's a work-in-progress)

Cheers
Ken