You can use the Dirty property to determine whether the current record has been modified since it was last saved. For example, you may want to ask the user whether changes to a record were intended and, if not, allow the user to move to the next record without saving the changes.
Setting
The Dirty property uses the following settings.
| Setting | Visual Basic | Description |
|---|---|---|
| True | True (–1) | The current record has been changed. |
| False | False (0) | The current record has not been changed. |
This property is available in Form view and Datasheet view.
This property set or read using a macro or Visual Basic.
Remarks
When a record is saved, Microsoft Access sets the Dirty property to False. When a user makes changes to a record, the property is set to True.