hi... im finding an error in the following statement...
here department is my database name... n deptid n deptname is the name of the fields on the form...

when i run the form it shows "No value given for one or more parameters."

sql = "INSERT INTO Department(Department_ID,Department_name)VALUES(deptid,Text2)"

please help me out as only after this i'll be able to continue!

sql = "INSERT INTO Department(Department_ID,Department_name)VALUES('" & deptid & "','" & Text2.Text & "' )"
commented: always help +1

thankx a lot! worked great!

sql = "INSERT INTO Department(Department_ID,Department_name)VALUES('" & deptid & "','" & Text2.Text & "' )"

You're Welcome....
Don't Forget to mark this thread as Solved :)