Hello VB users,

I am trying to insert via SQL a record in my table.

Source:

Private Sub Form_Load()
Set DB = OpenDatabase("c:\q.mdb")
Dim QQQ As String
QQQ = "test"
DB.Execute " INSERT INTO MyTable " _
& "(MyField) VALUES " _
& "(QQQ);"
End Sub

error message: Too few parameters!

Normaly is variable QQQ a hard coded string like: "Test".

How do I change the SQL code so it accept a varible?

Thanks for reading,

Michelle.