Data updation

[Sweet Virgo]

hi friends i am working on ms access front end, i have Edit form which cotains a combo box this combo box is bound with a table named Department, this combo box have names of departments which have entered in the table, i want at run time when i select a department name from this combo box other information related to this department will be display in respective text boxes of the form. i am using the following code it gives a etrror there Private Sub cmbSectorName_Change() Dim rst As ADODB.Recordset Dim ch As String ch = cmbSectorName.Value Set rst = New ADODB.Recordset rst.CursorLocation = adUseClient rst.Open "Select Description From tbl_Sectors where Name=ch", CurrentProject.Connection, adadOpenKeyset, adLockOptimistic txtDeptDescr.Text = rst.Fields(0).Value rst.Update rst.Close Set rst = Nothing MsgBox "Data Has Shown Successfully" End Sub when i change selected name of the combo box it gives error "No Value given for one or more parameter " and get focus to this line fo code rst.Open "Select Description From tbl_Sectors where Name=ch", CurrentProject.Connection, adadOpenKeyset, adLockOptimistic friends kindly can soem help me and second this it that after this i want to allow user to change soem information of this selefcted department and then on click event of Edit button it will updeated in data base i need ur help regarding these two problems may u guide me regards Farooq Azam