error in code

[krc777]

I have the following code in an Access module:

UPDATE MainRptDataASD SET PlanName = (SELECT Plan FROM CHPs, MainRptDataASD WHERE CHPs.PlanID = MainRptDataASD.PlanID)

I'm getting this error: Operation must use an updateable query.

This is an updateable query. I perform other updates and it works well. It seems that this SELECT Plan FROM CHPs, MainRptDataASD WHERE CHPs.PlanID = MainRptDataASD.PlanID is the problem.

Can anyone tell me why?
Thanks
k

 

[ByteMyzer]

In Access/Jet, this is NOT an updatable query.

Try this instead:
UPDATE MainRptDataASD INNER JOIN CHPs ON MainRptDataASD.PlanID = CHPs.PlanID
SET MainRptDataASD.PlanName = CHPs.Plan;

 

[krc777]

That worked great! Thank you so much.