The form Current event (or On Current event) activates when the focus moves to a
record on the form. This action makes this record the 'current record'.
This event also occurs after a form is opened, requeried or refreshed.
Current Event Example:
In this example we change the field Due_Date to red when the
value of this field is less than today's date and the field Completed=false.
Private Sub Form_Current()
If Me!Due_Date < Date and Me!Completed=False Then
Me!Due_Date.BackColor = 255
Else
Me!Due_Date.BackColor = vbWhite
End If
End Sub
The event sequence for the Current Event is:
Open → Load → Resize → Activate → Current
