my problem is centered on the txtpdetails textbox section. Whenever a value with ' such as "It's a wonderful day" is type in the textbox and error occurs due to the quotation mark.

Is there anyway around this problem? Other than having to make the user go type "It''s a wonderful day" ?

s_sql = "Insert into " & s_tblname & (quot_no, prod_no, prod_details, prod_qty, prod_price, prod_amount)
values ('" & txtrefno & "','" & s_current & "','" & txtpdetails & "'," & txtqty & "," & s_curr & "," & s_curr2 & ")"
env.cnn.Execute s_sql