Problem when adding a new record using VB

Hi,

I have a database with one Table and one Form.

The table "Table1" fields:
ID (AutoNumber),
Date (Date/Time),
Mark (Number)

In Form "Form1" is a button. When I press the button I want to add a new record in table "Table1" with these values:

"17-jan-2009"

and "15" for Date and Mark.

Currently I have this code for onClick event:

Please Login or Register  to view this content.

But I get an error: "Syntax error in INSERT INTO statement". Why ? Because of field ID which is AutoNumber type ?

This should work:

Please Login or Register  to view this content.

There are a few things wrong with the original phrasing. In Access, Dates are surrounded by a #. Also the [Mark] field is a number, which doesn't require a pair of single quotes around it. The single quotes would infer a text value. The Insert stament also requires a following Select statement (query) to insert the values. Finally, it's not a direct issue in your failure, but be careful with using [Date] as a field name. "Date" is a reserved word (designating a data type) and can get you into trouble when using it as a field name (the voice of hard experience). Hope this helps...

Brent