Mengelak data diedit secara tidak sengaja

Salah satu cara yang mudah adalah seperti berikut (Access 2007) : 

• Buka Form dengan format Design
• Buka property pada Field yang hendak diubah dan buat:
  • Lock > Yes
  • On key Down > click Event Procedure & masukan kod di bawah ... cth kita nak ubah Filed 'Nama'

Private Sub Nama_KeyDown(KeyCode As Integer, Shift As Integer)
'If the field is not flagged for editing, prompt the user
'for confirmation about unlocking the control.
    If fEditNama = False Then
        If MsgBox("Do you want to change the Nama for this property?", _
                  vbYesNo + vbQuestion + vbDefaultButton2, _
                  "Please Confirm:") = vbYes Then

            'If the response is Yes, unlock the field
            'and flag it as being edited.
            Me!Nama.Locked = False
            fEditPropertyNama = True
        End If
    End If
End Sub