Check box on subform not working

  • Thread starter Thread starter Mark Hammer
  • Start date Start date
M

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't change recourdsource in subform 4
Error 429 ActiveX and DAO360.dll 2
Spell checker broken 5
Too few parameters in report_open using crosstab query 2
edit a bound textbox control on a form 3
Filter subform with combo box on main form 1
Check box on a subform 1
Passing a value from subform or main form to subform query 4

Back
Top