I would check that your primary key column is an autonumber field.
Also, try writing the
SQL string (I'm sure you can get to that) to the screen to make sure the syntax is correct.
Lastly, try checking the submitted data is valid and that nessesary fields have been filled in.
Maybe there is a field in the database that is required, and you have not included a box for it on the form perhaps?