What Are the Form Events, and When Do You Use Them?

Microsoft Access traps (responds to) for 31 Form events (excluding those specifically related to Pivot Tables), each of which has a distinct purpose. Access also traps events for Form sections and controls. The following sections cover the Form events and when you should use them.

Current

A form's Current event is one of the more commonly coded events. It happens each time focus moves from one record to another. The Current event is a great place to put code that you want to execute whenever the user displays a record. For example, you might want the cursor to move to the contact first name control if the user moves to a new client. The following code is placed in the Current event of the frmClients form that's part of the hypothetical time and billing application that we've been building in the previous chapters: