>Does anyone know what the correct syntax for an update command is?
>
>I tried the following with no luck:
>
>

DOCMD.RunSQL("Update mytable Set myfield = "FRED" WHERE myfield2 <> 9 ")

You have to escape the quotes or use single quotes:

DOCMD.RunSQL("Update mytable Set myfield = 'FRED' WHERE myfield2 <> 9 ")

HTH