checkbox inserts ok, but doesnt show on update page 1

[puterdude]

Hi,

I'm using checkboxes. When I click the checkbox, and hit submit, it correctly stores the value "Y" to the access database table.


When I go back to the record on an update asp page, the value is not checked, though the underlying value in the table is "Y".

I'm sure I'm not understanding something here. Any ideas?

Thanks.

 

[foxbox]

A checkbox is on/off; not Yes/No.


You're update form should containt something like this:

response.write &quot;<input type=checkbox name=field1&quot;
if rs(&quot;YNfield&quot = &quot;Y&quot; then response.write &quot; checked&quot;
response.write &quot;>&quot;

br
Gerard

 

[puterdude]

Hmm.. Tried it but keeping getting syntax errors or compilation errors.

Can someone show me the syntax for this?

THanks.

 

[puterdude]

Never mind. Got it.
..then response.write(&quot;checked&quot <<<---needed the parens

Thanks a lot.

Puterdude