Using SQL to modify a record.

[zapras]

Im still very new to access and probably way off track here.
But Im trying to create a SQL statement to overwrite an existing single record in access.
I tryed using this statement but it comes up with an error saying "query input must contain at least one table or query." ive been trying for a couple of hours and thats the error i get basiclly saying im way of track. Can anyone help please? The code i have so far is...

Dim mySQL As String
mySQL = "INSERT INTO Journal ( Description )"
mySQL = mySQL + " VALUES (Me![Comment])"
mySQL = mySQL + " WHERE (((Journal.'Journal ID') = 3))"
DoCmd.RunSQL mySQL

The tables name is Journal and the field is called Description and the record is 3 of the "journal ID"'s Autonumber. The data i want in there is from (Me![Comment]) Hope that all makes sense.
Thankyou for your help! :)

[mshmyob]

Looking quickly at this I would put Journal ID in square brackets not single quotes.

You should get into the habit of never using spaces for naming conventions.

cheers,

[zapras]

Thanks for that. But im thinking why it dosnt work is because you cant have a WHERE statement in a INSERT INTO statement

Can someone else please help me with this? Maybe with an UPDATE statement?
Trying my hardest but i just dont know enough about it. (and dont know how to learn it for that matter)
Thankyou!

[ChipR]

"UPDATE Journal SET Description = """ & Comment & """ WHERE Journal_ID = 3"