Hello, i'm having some issues finding out how to trigger a Boolean in the same table as a selected value the user gets from a combo box.
What I need to have happen is once the user selects an employee from a combo box and hits the save button, a Boolean in the table is turned on. The Boolean is called [OnJob], and is connected to an update query that will only display an employee with [OnJob] = False. The only problem is, I don't know what the syntax would be and have had no luck on the web so far on finding out how to change that value to yes.

Summary: I need to know the Syntax to create a button at the end of a form to turn the selected Combo box's values to true in their corresponding Boolean field in there corresponding tables, thus next time I open the from their names will not be a selection in the combo box.

Any help is greatly appreciated,
Thank You