When interacting with forms or controls, various events can be triggered based on your actions. These events encompass control events such as Exit, LostFocus, Enter, GotFocus, and Click, among others. Additionally, there are form events like Current, Before/After Update/Insert, and even mouse movements. The specific events that occur depend on your layout and the state of your form.
For example, let's say you had the focus on a main form control, such as a textbox, before entering a subform control. If you then return to the main form by clicking on another control, like a combobox or another textbox, a different set of events will be triggered. Furthermore, the version of Access you're using will also impact which events are fired.
To accurately determine which events are being triggered and their order of execution, it is best to initialize all relevant events and have them print their names. Here's an example:
Private Sub Form_Current()
Debug.Print "Form_Current"
End Sub
It may not be necessary to do this for all events, such as mouse movement events.
