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
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