Editing a field using vba onclick

[Grant Shea]

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,

[ranman256]

The button click would run your update query using a macro.
in the macro run OPENQUERY.

the query uses the items on the form...
update table set [field] = forms!frmMyForm!cboRound

[ItsMe]

Are your combos dependent on each other? If your tables are structured correctly and the combos are dependent, it should be as easy as building a query that uses the last combo as criteria.

Have you tried building a query object using the designer? You could use the Update tool within the designer and include your combo name in your query. Granted, you have to have the corrected Bound Column property for your combo.

[Grant Shea]

I figured it out i changed the underlying "question selection query" to an update query and inserted a docmd.runquery line in the on click field for the button.

[ItsMe]

Glad to hear you are managing to work through these types of issues. I would like to reemphasize a point. Make sure that you include the appropriate criteria. Perhaps you need to include the value of more than one combo.

The UPDATE statement is powerful and irreversible. The UPDATE query is unmatched in its capability of creating memorable events on a resume.