Report.Current event (Access)

Occurs when the focus moves to a record, making it the current record, or when the report is refreshed or requeried.

Syntax

expression.Current

expression A variable that represents a Report object.

Remarks

To run a macro or event procedure when this event occurs, set the OnCurrent property to the name of the macro or to [Event Procedure].

This event occurs both when a report is opened and whenever the focus leaves one record and moves to another. Microsoft Access runs the Current macro or event procedure before the first or next record is displayed.

By running a macro or event procedure when a form's Current event occurs, you can display a message or perform an operation related to the current record.

The Current event also occurs when you refresh a report or requery the report's underlying table or query—for example, when you use the Requery action in a macro or the Requery method in Visual Basic code.

When you first open a report, the following events occur in this order:

Open → Load → Resize → Activate → Current

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.