check box yes to automatically make cbo1, cbo 2, cob 3 equal yes

[mlrucci]

Good afternoon,


I am looking to make an unbound check box default no but if clicked to yes, then make cbo1, cbo2, cbo3 yes, else blank to allow yes or no. I want an entire row (cbo1, cbo2,cbo3) to be yes if the ckeckbox is clicked but allow the field to be either yes or no if unclicked. Anyone have ideas? Just a note, the cbo field is list with "Yes"; "No" in the table's row source.

Tried
If me.ck0 = Yes then
me.cbo1 = "Yes"
End If

and cannot get the single cbo field to work much less several fields.

Much Thanks

[ranman256]

in the AFTERUPDATE event of the check box

sub chkBox_afterupdate()
if chkBox.value then
   cbo1 = "yes"
   cbo2 = "yes"
   cbo3 = "yes"
else
   cbo1 = null
   cbo2 = null
   cbo3 = null
endif
end sub