I want to see if I'm missing something easy:

I have a checkbox on form that, when checked, changes the background color of a related text box (and changes it back when unchecked). This is done using VBA. The value represented by this checkbox is saved in a Yes/No variable in the main table.

I have a simple If-Then-Else statement associated with the Click event of the checkbox. This changes the color when I click on the checkbox on the form.

My question concerns moving from record to record in the form.

To reflect this correct status of this checkbox on the form for the other records, the solution I'm using is to use the same If-Then-Else statement to the Form_Current sub, so that when the form moves to the next record, it looks at the value of the checkbox and processes the If-Then-Else statement.

Is there a more correct or more efficient way of doing this that I don't know about?

Thanks.