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
| Private Sub Commande72_Click()
On Error GoTo Err_Commande72_Click
If Me.ID_TVA_Double = "11" Then
Select Case Me.ID_Analaytique
Case "1", "2", "4", "5", "6", "7", "9", "10", "12", "14", "21", "22"
DoCmd.OpenReport " ETA-FACTURE FI autoliquidation", acNormal, , "[IDFACTUREFI]='" & Me![IDFACTUREFI] & "'"
Case "23"
DoCmd.OpenReport " ETA-FACTURE FI ENTRETIEN autoliquidation", acNormal, , "[IDFACTUREFI]='" & Me![IDFACTUREFI] & "'"
End Select
Else
Select Case Me.ID_Analaytique
Case "1", "2", "4", "5", "6", "7", "9", "10", "12", "14", "21", "22"
DoCmd.OpenReport " ETA-FACTURE FI ", acNormal, , "[IDFACTUREFI]='" & Me![IDFACTUREFI] & "'"
Case "3"
DoCmd.OpenReport " ETA-FACTURE FI ENTRETIEN ", acNormal, , "[IDFACTUREFI]='" & Me![IDFACTUREFI] & "'"
End Select
Exit_Commande72_Click:
Exit Sub
Err_Commande72_Click:
MsgBox Err.Description
Resume Exit_Commande72_Click
End If
End Sub |
Partager