I don't remember why, because I've been doing it this way for a long time, but any Boolean fields in my subforms are not using initial values. I set them to an initial value via programming (in the On Form Change event). Something like the following:
if @IsBlank(Reconcile)
     Reconcile = 1

Hi Carl,
On form change event, this code runs every time any element in the form changes. It will keep on firing every time enter or change data.  Let's see,  you entered the form and changed something or on Form entry programming changed something and Check box is checked automatically. Now you go and unchecked that box. You change something else in the form and checkbox will be checked again.  Well, that is what I think!!

This code should be on On Form Entry event for it to work properly and preferably with @IsNew condtional so, it does not change again when you re-enter the form in update mode, once you have manually unchecked it.  


Quote:


Is "0" considered blank? Possibly not.
Since there are 3 possible values for check box, I usually use something like:

If Reconcile <> 1 then
       {
              Reconcile = 1
       }

The checkBox element is a little complicated one and I would like to understand the behavior of it for it to work correctly.


Bharat

Bharat_Naik wrote on Mar 4^th, 2009 at 4:42am:

Not so, the @IsBlank conditional will ONLY allow a change if it's blank; which means this can only happen the first time you ever make a change to the form, and never again (unless you deliberately clear the element in question).


Quote:

This does not work for the first line item in a table-view subform. Plus, it will cause a new line item to be created every time you press the down arrow, even if all the other fields are left blank.


Quote:

No, it's considered to have a value. @IsBlank will work with a Boolean field the way you would expect it to.


Quote:

You wouldn't want to use this for an initial value, because it would change it to "1" no matter what state the field was in.

Thanks Carl. My thinking was more hypothetical. Since, you have used it and it works as it is supposed to, that is the way to go. Thanks again for detailed explanation.