iif in query

[AccessPro]

I'd like to write an if statement where a parameter result updates a field. I will try to explain:

if ([would you like to update the field?] == "yes") then it updates it.

[ranman256]

you dont ask this in the query. do it in code:

if msgbox("Update the field",vbyesNo,"confirm") = vbYes then docmd.openquery "quUpdQry"


...unless you are actually updating that field to yes/no or other:
update table set [yesNoFld]= [Update this field]

then the field will get the reply the user enters.