I want my Sales Order control to change color whenever a sale has been set to "completed" in a click box.
No problem, normally, just set a form current event like this:
If Me.COMPLETED_TRANSACTION = True Then
Me.SO_NUMBER.BackColor = 8421504
ElseIf Me.COMPLETED_TRANSACTION = False Then
Me.SO_NUMBER.BackColor = 16777215
But now I am using a continous form and this means that if the first record has the clickbox checked all records SO controls will be grey and if not all controls will be white. The form current wont update between the records in a continous form.
How should I do? I have tried some other events but cant get it right. Can I set the Me argument to be valid only for the current record or is there an event that will do the trick?