Run-time Error '424': Object required

[MCCDOM]

Hi all,



I am getting this message pop up (Run-time Error '424': Object required) when I try and add the contents of the form to the table. Could somebody help please.

Many Thanks

Private Sub btnAdd_Click()


    Dim iCtr As Integer
    For iCtr = 1 To Me.txtQty
        strCurrentDB.Execute "INSERT INTO tblTest (Item & Date Purchased) VALUES ('" & Me.txtItem & Me.txtDate & "')"
    Next
End Sub

[pbaldy]

The syntax of the query is incorrect. Fields are separated by commas and fields with inadvisable spaces need to be bracketed. Date and text fields require delimiters. This may help:

http://www.baldyweb.com/BuildSQL.htm