When the query below is run, Access promts for an Parameter Value.
UPDATE 000140_MasterOrderNo SET [000140_MasterOrderNo].MasterOrderNumber = [000130_OrderAdded]![MASTER_ORDER];
I’ve run queries like this in the past without this problem and I cannot seem to solve this one.
As always ANY help is GREATLY appreciated!
Joe