INSERT INTO statement

[Todd Schei]

I'm trying to insert data into an existing record in my
table using "INSERT INTO"

All my values that I want to insert look fine when I
review in debug mode. The values don't show in table after
the "dbcurrent.Execute stSQL" statement. I get no
errors. Everything looks fine, except the record doesn't
change. What's wrong?

 

[John Vinson]

I'm trying to insert data into an existing record in my
table using "INSERT INTO"

Wrong tool. INSERT INTO does not do this! It creates a NEW record.

Use an Update query joining the two tables instead.

 

[Tim Ferguson]

I get no
errors. Everything looks fine, except the record doesn't
change.

Like John says. And I suggest using the dbFailOnError option of the Execute
method, so if there is a problem with the SQL you get told about it.

HTH


Tim F