Insert Error

[Abdlah]

have an access database with all the fields but PRICE (which is defined as currency) as text and when I submit the values from my form I receive an error (error information is attached in code section). What is it I am doing wrong?

[Dan_Bracuk]

Step 1 - get rid of the brackets surrounding your form variables.

Step 2 - if Step 1 doesn't work. Comment out all but the last fieldname and value and try your insert query. If it works, uncomment them one by one until it fails. Then you'll know what the problem field is. My guess is that it would be price, because of the datatype.

[Magikaru · Accepted solution]

You're missing a closing parenthesis for Values.