I am tring to use an inser sql to update the database.

insertSQL = "INSERT INTO Supportcall(ID,Contact,Description)" & " VALUES(txtcallnumber.text,txtcallcontact.text,txtcalldescription.text)"

where txtcallnumber.text are cells in the form.

When I run the app, the exception message is No Value Given for one or more parameters.

The access 2k table only has the 3 fields outlined above

If I 'manually' insert the record it works fine.

insertSQL = "INSERT INTO Supportcall(ID,Contact,Description)" & " VALUES('2','Fred Atkins','This is the description')"

Furthermore, I have a declared the fields as
dr = dssupport.Tables("Supportcall").NewRow()
dr("ID") = txtcallnumber.Text
dr("Description") = txtcalldescription.Text
dr("Contact") = txtcallcontact.Text