I have a form that has 3 combo boxes that sets the criteria for a query. At the bottom of this form is a button. What i would like to happen is when i click the button it updates the Yes/No field associated with the record matching the three combo boxes to Yes without opening the table.
I have included two attachments one is the "Invalidate Form" which contains the lookup combo boxes and the button i would like to use to invalidate the question.
The second attachment is the "Questions" table which contains all the records.
Thanks,