The query should be an update query, not a select query. An update query would not show you any results, just updated the fields as intended, without input from the user.
Originally Posted by kableland
Code should look like;
note the 'UPDATE' at the begining and not 'Select'
UPDATE tbl1HeaderInfo SET tbl1HeaderInfo.SubmitYesNo = True
this is pretty much what June7 suggested as well, except this is a saved query, while his was in VBA.
my other two cents:
Avoid using '-' in form, table, or field names. one problem specifically is when you copy and past it in access it wants to change '[frmHeaderInfo-Edit]' to '[frmHeaderInfo]-[Edit]'