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 28 29 30 31 32 33 34 35 36
|
Option Compare Database
Option Explicit
Private Sub Modifiable2_AfterUpdate()
Select Case Me.Modifiable2
Case "12"
Forms.frm_duree.SFRM_DUREE.Form.duree1 = DateAdd("m", Me.Modifiable2, (Me.Date))
Case "14"
Forms.frm_duree.SFRM_DUREE.Form.duree1 = DateAdd("m", 12, (Me.Date))
Forms.frm_duree.SFRM_DUREE.Form.duree2 = DateAdd("m", Me.Modifiable2 - 12, (Me.Date))
Case "18"
Forms.frm_duree.SFRM_DUREE.Form.duree1 = DateAdd("m", 12, (Me.Date))
Forms.frm_duree.SFRM_DUREE.Form.duree2 = DateAdd("m", Me.Modifiable2 - 14, (Me.Date))
Forms.frm_duree.SFRM_DUREE.Form.duree3 = DateAdd("m", Me.Modifiable2, (Me.Date))
Case "24"
Forms.frm_duree.SFRM_DUREE.Form.duree1 = DateAdd("m", 12, (Me.Date))
Forms.frm_duree.SFRM_DUREE.Form.duree2 = DateAdd("m", Me.Modifiable2 - 14, (Me.Date))
Forms.frm_duree.SFRM_DUREE.Form.duree3 = DateAdd("m", Me.Modifiable2 - 18, (Me.Date))
Forms.frm_duree.SFRM_DUREE.Form.duree4 = DateAdd("m", Me.Modifiable2, (Me.Date))
Case "36"
Forms.frm_duree.SFRM_DUREE.Form.duree1 = DateAdd("m", 12, (Me.Date))
Forms.frm_duree.SFRM_DUREE.Form.duree2 = DateAdd("m", Me.Modifiable2 - 14, (Me.Date))
Forms.frm_duree.SFRM_DUREE.Form.duree3 = DateAdd("m", Me.Modifiable2 - 18, (Me.Date))
Forms.frm_duree.SFRM_DUREE.Form.duree4 = DateAdd("m", Me.Modifiable2 - 24, (Me.Date))
Forms.frm_duree.SFRM_DUREE.Form.duree5 = DateAdd("m", Me.Modifiable2, (Me.Date))
Case Else
Call Err.Raise(5, , Error$(5) & " - Durée non gérée.")
End Select
End Sub |
Partager