Trying to get a Update statement to work

[itm]

Hi,
This should be simple but for some reason is not working in Access.
I tryed putting this in a query and VBA as I have below, but I keep getting the error message "Operation must use an updatable query"; but I am not sure why or what to do about it. Any ideas here would really be appreaciated.
Thank you



My code:

 Set cn = CurrentProject.Connection
str = "UPDATE tblCom07WorkingNew SET tblCom07WorkingNew.Level3 = (SELECT tblCom07Dump.[Proj def] FROM tblCom07Dump INNER JOIN tblCom07WorkingNew ON tblCom07Dump.PeggedRqmt = tblCom07WorkingNew.Network);"
        cn.Execute str

[NTC]

well this is one time the error message tends to be literally correct. it isn't the code syntax. what you need to do is run that target query just a simple standalone select query manually - and note if it is indeed not updateable (you won't be able to change any text in any field)....

there are lots of Q& A on what defines/creates an updateable query. it is a common issue... this is what you have to solve. No single post in a forum can say do x,y or z....it will depend on your data & structure.

Sorry not to be more helpful.

[itm]

Well thanks, I will look into what make an updatable query.