Insert information into a table dynamically?

[erwin001]

I'm using the code listed below to insert a dollar sign into an existing table. The record id's already exist in the table. For each specific record, I want to place a dollar sign in the cell based on the record ID. This code doesn't work. Can anyone offer any suggestions.

DoCmd.RunSQL "INSERT INTO TBL_LoadReport ([" & insertfieldx & "]) VALUES ('$')WHERE [Report ID] = 7"

 

[Remou]

If the record exists, I think you need an update, rather than an append, query:
[tt]"UPDATE TBL_LoadReport SET [" & insertfieldx & "] = '$' WHERE [Report ID]=7"[/tt]

 

[erwin001]

Thanks.