Recordset

[Sweet Virgo]

hi friends i am woking on MS Access forms with MS Access Database. i want to add text boxes' data into table on click event of a buton. i am using buttons and want to use recordset object. i don't know how to open recordset and how to insert data in table from this button. i am using this code it gives syntax error ont insert statement but i have checked my statement is correct. ___________________________________ Option Compare Database Dim rst As ADODB.Recordset =========================== Private Sub cmdAdd_Click() Dim Did As Integer 'dim Dname as 'Set db = Humaintarian.mdb' 'Set rst = db.OpenRecordset("tbl_Dept") '.OpenRecordset("tbl_Dept") 'tbl_Dept is the table 'rst.AddNew txtDeptId.SetFocus 'We have to set focus for each field MsgBox ("txtDeptId=" & txtDeptId.Text) 'Just see what we got 'Did = txtDeptId.Text 'rst!Id = txtDeptId.Text txtDeptName.SetFocus 'We have to set focus for each field MsgBox ("txtDeptName=" & txtDeptName.Text) 'Just see what we got 'rst!Name = txtDeptId.Text txtDeptDescr.SetFocus MsgBox ("TxtDeptDescr=" & txtDeptDescr.Text) 'rst!Description = txtDeptDescr.Text 'rst.Update 'rst.Close INSERT INTO tbl_Sectors(Id,Name,Description) VALUES(txtDeptId.Text,txtDeptName.Text,txtDeptDescr.Text) End Sub __________________________________ friends plz help me i am stucked regards Farooq Azam