executing update query

[deepcec9]

Hi,

I am trying to run an update query which updates the value in a sub form to another table. Set a macro "open query" to a command button, when I click on command button a pop up window appears with message "Enter parameter value (field_name)".
tried the same query in another FORM it is working fine. Please find the attached screen shot of query.
TIA

 

[arnelgp]

is it a Parameter query?

 

[deepcec9]

Thankyou for the reply, figured out. Changed the criteria to
[Forms]![frm_jobout1]![out Subform1].[Form]![productid_out]= [in].[productid_in]

Working fine now