how to update on table

[qplcjp]

I have on the form and subform like below, I would like to know why
the data on the field countAA, countBB and countCC will not update on
the table.
Please help

txtSubAA, txtSubBB, txtSubCC
and set their visible property to No.

Give them these controlsources.
txtSubAA
=Sum(IIF(select2 = "AA",1,0))
txtSubBB
=Sum(IIF(select2 = "BB",1,0))
txtSubCC
=Sum(IIF(select2 = "CC",1,0))

Then in your main form.
countAA
=IIF(select1 = "AA",1,0) + Nz(chpsubform.Form!txtSubAA)
countBB
=IIF(select1 = "BB",1,0) + Nz(chpsubform.Form!txtSubBB)
countCC
=IIF(select1 = "CC",1,0) + Nz(chpsubform.Form!txtSubCC)