Ken,

  I looked at your example page on updating multiple records. I understand
the logic behind it. However, I'm trying to get the values from checkboxes
into my table. It seems to work fine if the checkbox is checked, but I get
an error when the checkbox is unchecked. Any suggestions on how I should go
about doing this?
  I'm using Access 2000.

Any help is greatly appreciated!

--Ashley

When a checkbox is not checked, nothing is sent to the server.

What I suggest you do is either:
a) embed a master list of all checkboxes into your webpages as a hidden form
element
    -or-
b) (more secure) reassemble the master list of checkboxes on the server (eg
from the database). Check the corresponding Request.Form() collection
element to see if the element is there. If it is not, then it wasn't checked
(so update the record and set the value to False)

Cheers
Ken

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


:   I looked at your example page on updating multiple records. I understand
: the logic behind it. However, I'm trying to get the values from checkboxes
: into my table. It seems to work fine if the checkbox is checked, but I get
: an error when the checkbox is unchecked. Any suggestions on how I should
go
: about doing this?
:   I'm using Access 2000.

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