Run-time Error 3067 - Query input must contain at least one table or query

[Janoose]

Sorry for the long title. This is my code

  
sqlString2 = "insert into centres (Ethics_Renew_Date) values ('" & renewDate & "') where CENTRE_CODE = '" & centreCode & "'"
DoCmd.SetWarnings False
Debug.Print sqlString2
DoCmd.RunSQL sqlString2

The debug.print outputs this:
insert into centres (Ethics_Renew_Date) values ('2012-05-27') where centre_code = '999-999'

Table is correct called Centres, and the field name Ethics_Renew_Date and centre_code I copied right out of my table so spelling is correct.



When I took out where CENTRE_CODE = '" & centreCode & "'" the code works

[pbaldy]

You can't have a WHERE clause with a VALUES clause (you could use it with a SELECT clause). A VALUES clause by definition only inserts a single record, so a WHERE clause would be meaningless anyway.

[Janoose]

Yes I should have used Update instead of Insert in order to use Where.