1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| Private Sub a_BeforeUpdate(Cancel As Integer)
Dim strA As String, Cnt As Long, Rps As Integer
strA = Nz(Me.a)
If strA <> "" Then
Cnt = DCount("*", "NomDeLaTable", "a='" & strA & "'")
If Cnt > 0 Then
Rps = MsgBox("Une entrée existe déjà pour " & strA & vbCrLf & _
vbCrLf & _
"<Oui> : Modifier entrée existante" & vbCrLf & _
"<Non> : Modifier saisie en cours" & vbCrLf & _
"<Annuler> : Abandonner saisie en cours", vbYesNoCancel, _
"Modifier l'entrée existante ?")
Select Case Rps
Case vbYes
Me.Undo
DoCmd.FindRecord strA, acEntire, , acDown, , acCurrent, True
Cancel = True
Case vbNo
Cancel = True
Case vbCancel
Me.Undo
Cancel = True
End Select
End If
End If
End Sub |
Partager