using code to change data in another table (1 Viewer)

[Jon123]

I'm working off a form that had a combo box that lets me select a selection from data entered in another table. In the main table I have a Yes/No field. When I select from that combo box how can I change the Yes/no field for that selection? In the after update of the combo but don't know how to change the record in that table.

thanks

jon

 

[pbaldy]

Either an update query or the edit method of a recordset, either using the combo as the criteria.

 

[Jon123]

thank you that worked

 

[pbaldy]

Happy to help!