copying a record to another table

[ghayman73]

hi i am trying to copy current record "which has only one field" to another table.

I am trying this but keep getting an error

Dim strSQL As String
strSQL = "INSERT INTO [ignore_list] ([keyword]) VALUES (Me!keyword);"
CurrentDb.Execute strSQL


error:

Run Time Error '3061':

too few parameters. Expected 1


any ideas or am I missing something

thanks Grant

 

[spiralmind]

try using this syntax:

docmd.runsql strSQL

 

[ghayman73]

Its running now thanks spiralmind.

BUT!! its asking for (Me!keyword) is that the correct syntax for current form.

thanks again.

Grant

 

[spiralmind]

do you have a control named "keyword", if so you might want to try putting a ".value" at the end of the SQL parameter, or naming the form explicitly to clear up any confusion access must be experiencing when it asks you who "me" is and what its "keyword" is equal to.

 

[ghayman73]

sorted thanks for your time.