I have a listbox populated with Users and a checkboxlist that is filled with report numbers.

Once a person clicks on a User i'm wanting the corresponding reports to be checked in the checkboxlist.

i know how to fill the checkboxlist but i dont know how to check the boxes once a user is selected.

Code:
        OpenDataSet(dsBound, "SELECT BlockerNum FROM tblSQLReports ORDER BY BlockerNum ASC", "tblSQLReports")
        chkFields.DataSource = dsBound.Tables("tblSQLReports")
        chkFields.DataTextField = "BlockerNum"
        chkFields.DataValueField = "BlockerNumID"
        chkFields.DataBind()