INSERT INTO query in VBA

[jgelpi16]

I'm confused. I thought this would work just fine but I keep getting an error stating "Query input must contain at least one table or query." I must be missing something because I feel pretty confident that Table1 is my table....

mySQL = "INSERT INTO Table1 (LastUpdateUser, LastUpdateDate) VALUES ('" & varUser & "', #" & varDate & "#) WHERE ([PriID] =  '" & varID & "')"
    CurrentDb.Execute mySQL, dbFailOnError

[weekend00]

mySQL = "INSERT INTO Table1 (LastUpdateUser, LastUpdateDate) VALUES ('" & varUser & "', #" & varDate & "#) WHERE ([PriID] = '" & varID & "')"

you should not use a where clause after values ().

[jgelpi16]

Ok, where should the "WHERE" go then? When I put it inbetween the "INSERT INTO" and "VALUES" I got a Syntax error.

mySQL = "INSERT INTO LevyTable (LastUpdateUser, LastUpdateDate) WHERE ([PriEntityID] =  '" & varEntityID & "') VALUES ('" & varUser & "', #" & varDate & "#)"
    CurrentDb.Execute mySQL, dbFailOnError

Returns "Syntax error in INSERT INTO statement"...

[weekend00]

you don't need a where clause since you are simply adding one record with values

[weekend00]

Do you want to update a record in table1? then you need an update query, not insert into.

[jgelpi16]

Ok, then I am going about this all wrong. I need to run an UPDATE SQL, not INSERT INTO....