Error during compilation (If and ElseIf)

[Akchayan]

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:

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?

[pbaldy]

What's the error description? I'm not familiar with IsNotNull, which I suspect is invalid. Try

ElseIf Not IsNull(Me!FilterDatumVon)

[pbaldy]

Oh, and if this is really all on one line, it can't be:

If IsNull(Me!FilterDatumVon) And IsNull(Me!FilterDatumBis) Then DoCmd.ApplyFilter , "[IDKunde] = [Forms]![foUmsatz]![cmbKunde]"

That would be mixing the one-line and block formats of If/Then and will throw a compile error. Drop the DoCmd... to the next line.

[Akchayan]

What's the error description? I'm not familiar with IsNotNull, which I suspect is invalid. Try

ElseIf Not IsNull(Me!FilterDatumVon)

Yes Thank you it worked

[pbaldy]

Happy to help!