Multiple Checkboxes, Same Name, One Recordset
This is driving me crazy!
I have checkboxes for days of the week, all named "AvailableDays". I want to be able to select multiple days, and write their values to one recordset in Access.
All I get is the name of whatever was the first checkbox selected (i.e. if I select "Tuesday, Wednesday and Thursday" only Tuesday gets stored in the database).
Here is the form code:
Code:
<input type="checkbox" name="AvailableDays" value="Sunday">
Sunday <br>
<input type="checkbox" name="AvailableDays" value=" Monday">
Monday <br>
<input type="checkbox" name="AvailableDays" value=" Tuesday">
Tuesday<br>
<input type="checkbox" name="AvailableDays" value=" Wednesday">
Wednesday<br>
<input type="checkbox" name="AvailableDays" value=" Thursday">
Thursday <br>
<input type="checkbox" name="AvailableDays" value=" Friday">
Friday<br>
<input type="checkbox" name="AvailableDays" value=" Saturday">
Saturday
...and here is my asp code:
Code:
RecordsetRS("AvailableDays") = Upload.Form("AvailableDays")
I know it's something simple, but I've been looking at this all day and my eyes are getting blurry!!!