1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Private Sub NumAuto_GotFocus()
dos = Me.dossier.Value
Select Case dos
Case "aa"
Me.NumAuto = Nz(DMax("NumAuto", "increment", "dossier = '" & Me.dossier & "'"), 710000) + 1
Case "bb"
Me.NumAuto = Nz(DMax("NumAuto", "increment", "dossier = '" & Me.dossier & "'"), 275000) + 1
Case "cc"
Me.NumAuto = Nz(DMax("NumAuto", "increment", "dossier = '" & Me.dossier & "'"), 100000) + 1
Case Else
Me.NumAuto = Nz(DMax("NumAuto", "increment", "dossier = '" & Me.dossier & "'"), 1) + 1
End Select
End Sub |
Partager