I have a form used as a subform on frmCreateInvoice.
It is displayed in datasheet view in the subform control.
It displays a few text fields, a boolean field (shown as a
checkbox control) and a numeric field. The subform is
fed by a query. When I open the main form, I often click
the checkbox control in the records listed in the subform
control, changing them from False to True. And in the
numeric field, I may change the displayed values. The
source query is comprised of several tables. Only one
table's values are affected by my actions. Both fields
that I modify are in the same table (TempTable) and that
table is the only one in the src query whose values are
changed by user intereaction on the form.
Interestingly enough, here's what I've discovered: The
underlying TempTable value is IMMEDIATELY affected
when I click a checkbox control, changing it from True
to False or vice versa. The same is NOT true, however,
If I type a new value into the number field and press ENTER.
Of course, if I move off the record both field changes are
saved to the underlying table TempTable, as would be
expected.
Why is it that clicking the checkbox associated with the
boolean table field results in instantaneous value change
at the table level?