Newbie question:
I am trying to retrive value from Access DB into a form for updating. All my textboxes retrieve values correctly, but my checkboxes display empty.

My coloumn (say: Toys) contains the value "Yes" when a supplier carries toys and contains no value if they don't carry them.

My code looks like this:
<input name="Toys" value="Yes" <% If Request.Form("Toys") = "Yes" Then Response.Write ("checked")%> type="checkbox"> Toys</td>

What am I doing wrong?

Thanks
M

Hi there,

It looks to me that you are not retrieving the value from the database, but from the form:

<input name="Toys" value="Yes" <% If Request.Form("Toys") = "Yes" Then Response.Write ("checked")%> type="checkbox">

I guess that Request.Form should be something like MyRecordset("Toys")

If you are using checkboxes, remember that they only return the value when they are checked. They will return the value (Yes in your case) when you provide one, or the word on when you leave out the value altogether.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

YES!! This worked! Thank you sooo much.

You're welcome ;)

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.