My problem is about 3 checkboxes that I want to link to 3 yes/no fields in my database.
I want to update some information and when I check/uncheck the checkbox in my ASP page I want to check/uncheck the yes/no fields.
This is the code that I am using:
IF Request.Form ("chksNeeds?.checked") = true THEN
if RS.Fields ("sNeeds?") = false then
RS ("sNeeds?") = true
if RS.Fields ("sNeeds?") = true then
RS ("sNeeds?") = false
It only works only once and only if the field in the database is set to TRUE. I know that unchecked checkboxes are not passed to the server...(I did a little research), but still don't have any clue on how to fix this problem!
Does anybody have any ideea on how to get this thing working?