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