I have a form displayed in datasheet view where the user can modify all but a few fields. In the form's BeforeUpdate event, i have the following code:
Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
    Dim ctrl As Control
    
    If Me.Dirty Then
        For Each ctrl In Me.Controls
            With ctrl
                If .ControlType = acTextBox Then
                    Debug.Print .Name
...