Yes/No Data Type in MS ACCESS

how do i set-up the 'FORM' ?

[RichDiaz]

What values do I use in my HTML Page FORM to submit to a "Yes/No" Datatype ?

I keep getting:

Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/agent/NewAgent.asp, line 132

thanks a bunch!

[Woz]

RichDiaz,

you have to use -1 & 0

checked = yes = -1
unchecked = no = 0

set your form field value to 1 and do something like this

If Request.Form("FieldName") = "1" then
strField = "-1"
else
strField = "0"
end if

Onya
Woz

[RichDiaz]

ok i figured it out and i do not get an error message anymore... HOWEVER when i select "YES" is does NOT check the box in the database.

Any ideas?

[RichDiaz]

nm I fixed my errors =)

thx