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

hi friends i am working in ms access forms,i have an updation form in my project which contains a combo box ,combo box is bound with deparmtner name field os department table, i want when ever user select a department name from thsi combo box all other information related to selected department will show in other text boxews of form and user can change ne entry and he can update db at buttons click event, i need ur help regardign all this best wishes regards Farooq Azam

hi friends i want to insert data in sql server db from asp .net form's text boxes , i want to create a class and insert data thru functions of that class can ne one help me regards Farooq Azam

thanks friend Dave i will need ur help in future too regards bye Farooq Azam

hi friends i am working in vb6, i have a main form which contains a menu and deferent menu item liek add edit delte etc i want when i click menu itemm Add a form will open on it, i di dnot now how i can do this help me plz regards Farooq Azam

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

hi friends how are all of Farooq Azam

i am using Ms Access Forms at front end and Ms ACCESS database at backend , i want to know how i can connect buttons of Ms Acees Forms with MS ACESS database ? can some one help me ? Farooq Azam