>which error?


'record source for data combo is as follows.

deptsql = "select deptid, deptid + deptname as codename from dept order by codename"

Set deptRS = New ADODB.Recordset
deptRS.Open deptsql, con

Set DataCombo1.RowSource = deptRS
DataCombo1.BoundColumn = "Deptid"
DataCombo1.ListField = "codename"
'Set con = Nothing

'save button having this code

rs.Fields(0).Value = Text1
rs.Fields(1).Value = Text8
rs.Fields(2).Value = Text2
rs.Fields(3).Value = Text3
rs.Fields(4).Value = DataCombo1.Text

' even i used dtacombo1.boundtext.....still same eoor.????any idea please...

rs.update

both employee table and dept table having deptid c(4).

' error is multiple step operation generated error, check each status value. cursor stop at datacombo1.text

What is actual fault.