Setting Bit Field Value using a Button

Maranda — Mon, 19 May 2014 19:43:18 GMT

I have a form that needs to allow users to either mark an item "complete" or save the entered data and return to it later. I want to use two buttons, one which sets the value of a bit field to 1/true/yes then submits the data to my data connection and another which just submits the data. The problem is whenever I try to use the button to set the bit field's value I end up getting a validation error. I've tried: 1, '1', 'True', 'Yes' - none of which worked. Has anyone else successfully used a button for this purpose?

Thanks,

Maranda

SQL Database Integration

Setting Bit Field Value using a Button