Hello together
I have created an If and ElseIf structure that should be called when a button is pressed, but I always get an error when compiling. Here I have the code:
Code:
If IsNull(Me!FilterDatumVon) And IsNull(Me!FilterDatumBis) Then DoCmd.ApplyFilter , "[IDKunde] = [Forms]![foUmsatz]![cmbKunde]"
ElseIf IsNotNull(Me!FilterDatumVon) And IsNotNull(Me!FilterDatumBis) And IsNull(Me!Kunde) Then
DoCmd.ApplyFilter , "[Rechnungsdatum] between " & Format(FilterDatum1, "\#yyyy\-mm\-dd\#") & _
" AND " & Format(FilterDatum2, "\#yyyy\-mm\-dd\#")
ElseIf IsNotNull(Me!FilterDatumVon) And IsNotNull(Me!FilterDatumBis) And IsNotNull(Me!Kunde) Then
DoCmd.ApplyFilter , "[IDKunde] = [Forms]![foUmsatz]![cmbKunde2] And [Rechnungsdatum] between " & Format(FilterDatum3, "\#yyyy\-mm\-dd\#") & _
" AND " & Format(FilterDatum4, "\#yyyy\-mm\-dd\#")
End If
What is the reason for the error?