I need to update values in a table (where they are null or zero) with
values from another table for the corresponding PopulationMemberID.
Now I now that you can't update where there is a join.. but the join
is in the nested select.. so it should work right?
CurrentDb.Execute ("UPDATE Samples SET
samples.SampleMemberEmployees=(SELECT pop.PopMemberEmployees FROM
population as pop WHERE [Pop].[PopulationMemberID]=[samples].
[PopulationMemberID]) WHERE nz(sampleMemberEmployees,0)=0 AND
SurveyID=" & CurrentSurvey)
when the query is executed i get: :"Operation must use an updatable
query. (Error 3073)"
I worked around this by creating a vba function accepting the Id as a
parameter.. but its slow..