Check box on subform not working

[Mark Hammer]

Greetings,

I have a subform in continuous forms mode. I have two textboxes and a check
box on the form. All 3 are bound.

Changes made in the textboxes update the records successfully. However,
clicking on the checkbox just gets me a "ping" but no change.

The form's recordsed is updateable; I can open the recordsource and in the
datasheet view I can update the yes/no field successfully.

Why would this work on the recordsource but not on the bound form?

TIA,

Mark Hammer
Lake Oswego, Oregon, U.S.

 

[Mark Hammer]

Problem solved, partly.

The problem checkbox had the TripleState property set to true. Setting that
to False allowed it to be updateable on the form.

Remaining question: Access help says that when Triple State is True, the
control steps among three stages, for true, false, and null. I was unable
to get the check box to do that, when set to Triple State. Perhaps in this
state it's read-only?

--Mark Hammer