Checkbox unchecked in update.php
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?