each cbo box has a query that looks at the previous combo
cboClasses query:
select class from tClasses where [StudentID]=forms!myform!cboStudent
cboAssingments:
select [Assignment] from tAssignments where [StudentID]=forms!myform!cboStudent and [Class]=forms!myform!cboClasses
when user picks a box item, refresh the combo and if it has 1 item , set it:
Code:
sub cboStudent_Afterupdate
cboClasses.requery
if cboClasses.listcount = 1 then
cboClasses = cboClasses.itemdata(0)
cboClasses_Afterupdate
endif
end sub