Checkbox unchecked in update.php

Good morning,
Running DA wizard to create my pages I formatted a field to use check box, if I check this box in update or insert page it adds a '1' to the database field. However when I next view this record in update page the check has been removed even though the database still has the record set as '1'. If a user then forgets to recheck the box and updates the form it removes the check from the record?

Its a simple 'UserActive' check box that tells us if a user is live on our DB.

I have run DA wizard on 3 occasions to check I haven't missed anything, am I doing something wrong?

Thanks

send a copy of the page please.

Originally Said By: Jason Byrnes

  send a copy of the page please.  

Hi Jason, page is attached, I have run wizard 5 times now just to double check I am not missing something [I probably am!].

On 4 occasions it created this code:
<input type="checkbox" name="ContactActive" id="ContactActive" value="1" />

On 1 occasion it created this code:
<input type="checkbox" name="ContactActive" id="ContactActive" value="<?php echo(str_replace('"', '&quot;', $row_WADAtblcontacts['ContactActive'])); ?>" />

I am using the top line at present, once checked in insert or update pages it writes '1' to db field and appears as '1' on results & detail pages, not a check box. If a user then updates that record the update page opens with check box unchecked, once record is saved it removes the check.

Regards

Gary

leave the value set to 1.

then in the property inspector, click the Dynamic button. Click the lightning bolt next to Check If and select the ContactActive column from the WADAtblcontacts recordset. In the Equal To section, enter 1.

Originally Said By: Jason Byrnes

  leave the value set to 1.

then in the property inspector, click the Dynamic button. Click the lightning bolt next to Check If and select the ContactActive column from the WADAtblcontacts recordset. In the Equal To section, enter 1.  

That's brilliant Jason, you have sorted again, much appreciated.

regards

Gary

Originally Said By: gary.brett434358

  That's brilliant Jason, you have sorted again, much appreciated.

regards

Gary  

Works perfect.