updating yes/no field in MS Access database

enigma82 · April 27th, 2005, 10:14 AM

Hello,

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:

Code:

IF Request.Form ("chksNeeds?.checked") = true THEN
    if RS.Fields ("sNeeds?") = false then
        RS ("sNeeds?") = true
    end if
ELSE
    if RS.Fields ("sNeeds?") = true then
        RS ("sNeeds?") = false
    end if
END IF

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?

Regards,

raj_makro · April 29th, 2005, 06:36 AM

Hi
Try the following
IF Request.Form ("chksNeeds?") = "on" THEN
inplace of
IF Request.Form ("chksNeeds?.checked") = true THEN

Regards
Raj

Regards
Raj

luckyfelix · May 6th, 2005, 11:04 AM

Possibly you could use form fields or drop down menus that when selected = a number. That way in your db it will always have a "yes" or "no" value based on the number assigned...
EG: Yes="-1"
No = 1

Then write a bit that says If the fiels is -1 then check yes, if field is 1 then check no.