Query Not Updating....asking for a parameter value

[dryjeans]

Hi,

I'm trying to use the results of a query to set the value of a yes/no field...Here is the code I have, but it still asks for a parameter value...If I type in a correct value, it will update the yes/no box...but why is it not autmatically updating???

"UPDATE [order] SET [order].[oversea order] = True WHERE [order].[order ID] = [Find duplicates for order].[order ID Field]"

orderID = Text
oversea order = yes/no

[Stewart Ross]

Hi. You cannot refer directly to another table which is not included in the update query unless you use a sub-query to do so. I have recast your UPDATE to use the find duplicates query as a subquery below.

UPDATE [order] SET [order].[oversea order] = True WHERE [order].[order ID] IN
(Select [Find duplicates for order].[order ID Field] FROM [Find duplicates for order]);

-Stewart