SQL.CommandText = "INSERT Into Jobs (JobNo, DateStarted, DateFinished, Customer, TotalFee, Notes, Open) VALUES ('" & varJobNo & "', '" & varSelectedDate & "', 'n/a', '" & varCustomerID & "', '" & GrandTotal & "', '" & varNotes & "', 'Yes')" My SQL statement works fine until I add the last field which is "Open" with a value of "Yes." The error is apparently in this part: & "', 'Yes')"

When does this error occur? During execution or when you simply try to run the program? (meaning it is a syntax error) If it is an actual SQL error that gets generated when you attempt to execute the TSQL statement, what is that error (meaning what does it say is the error)? It is possible that the field type OPEN is not a text field and/or that it does not allow for 3 letters. Let me know more details and I can help. Chi They mostly come at night...mostly.

For some reason it would not work with the field name "Open" when I changed it to "OpenClose" it worked fine. Thanks, Matt

Then the Field name must be OpenClose lol Chi They mostly come at night...mostly.

No, I mean I had to change the field name in the database as well as in the code from "Open."