Have a ComboBox selection Update/Edit table checkbox value to Yes

[lucky]

Need some help trying to figure out how to have a Subform ComboBox record selection to auto change a table record field value checkbox to either Yes/True/-1.

The table and record selected in the combobox is the same record that I need to have auto checked.

I was thinking on using OnGotFocus/OnLostFocus.

Having the combobox selection receive focus keeping the record checked and when it loses focus having the record remove the check in the checkbox.



Any assistance would be appreciated.

[June7]

We don't know nature of the data and why you want this behavior so can't say if it is best approach to meet your requirements. However, sounds like it will work. Try it and let us know if you encounter issue.