query is asking for parameter value

[H0MELY]

Thank you all for looking. I am running an update query and for some reason
Access is prompting me for a parameter value for
"qry_original_atm_model!model" I have has no luck making this message box not
pop up. The query seems to run fine if I just hit enter, but I would like
the message box to not appear. Any ideas? SQL is below.


UPDATE tbl_service_changes
INNER JOIN tbl_replaced_atms
ON tbl_service_changes.atm_id = tbl_replaced_atms.arq_atm_id
SET tbl_service_changes.Comments = "Replaced " &
tbl_service_changes!Comments & " on " & tbl_service_changes![Status Change
Date] & " replaced a " & qry_original_atm_model!model & " with a " &
tbl_service_changes!model
WHERE (((tbl_service_changes.Classification) Like "*gain*"));

 

[Duane Hookom]

You don't have the query in the UPDATE/FROM clause. I think you can get by with
UPDATE tbl_service_changes
INNER JOIN tbl_replaced_atms
ON tbl_service_changes.atm_id = tbl_replaced_atms.arq_atm_id
SET tbl_service_changes.Comments = "Replaced " &
tbl_service_changes!Comments & " on " & tbl_service_changes![Status Change
Date] & " with a " & tbl_service_changes!model
WHERE (((tbl_service_changes.Classification) Like "*gain*"));