View Single Post
 
Old September 20th, 2006, 11:33 AM
Odifius Odifius is offline
Authorized User
 
Join Date: Sep 2006
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Update Query Not Working

I am using this code to update a table with info from a different query, well that is my intent, but when I execute the query it pops up asking for a value for [QueryDefs]![Progress_Fit]![Long Seam]. I have tried not using a query result; I have tried to pull info from a form: [Forms]![Progress_Fit subform]![Long Seam] with the sam result. If i put in = 12 it works. It is frustrating. Here is the SQL:

UPDATE [Progress - Weld/Fit/Visual] SET [Progress - Weld/Fit/Visual].
            [Long Seam] = [QueryDefs]![Progress_Fit]![Long Seam]
WHERE ((([Progress - Weld/Fit/Visual].Type)="Fit"))
WITH OWNERACCESS OPTION;

Any thoughts would be appreciated.

JR