RunSQL INSERT INTO VALUES

[DBDave]

This works fine to insert avalue from a form text box into a table field:



DoCmd.RunSQL "INSERT INTO myTable(stringField1) Values ( [Forms]![myForm]!myControl)"

Now I want to also INSERT two additional fields, so:

DoCmd.RunSQL "INSERT INTO myTable(stringField1, smallIntField, stringField2 ) Values ( [Forms]![myForm]!myControl), x, y"

Where x is number 1
y is a string constant "Yes"

Can you help me out with the syntax for the x and y values? The delimeters confound me every time. Thanks.

[June7]

I use CurrentDb.Execute to avoid the popup warnings.

CurrentDb.Execute "INSERT INTO myTable(stringField1, smallIntField, stringField2 ) Values ('" & [Forms]![myForm]!myControl) & "', 1, 'Yes')"