IS NUll Date Field

[DAHMB]

How do I format the following to work properly?

Private Sub btnFilterOutstanding_Click()

Dim stFilter As String

    If "#Tables![tblMilitaryLeave]![DatePaid] ISNull#" Then
    stFilter = "Tables[tblMilitaryLeave]![DatePaid]"
    End If

    'Set the Filter property
    Reports!rptMilitaryLeave.Filter = stFilter
    Reports!rptMilitaryLeave.FilterOn = True

End Sub

Thanks
Dan

[beacon]

I think you need to write it like the following:

Private Sub btnFilterOutstanding_Click()

Dim stFilter As String

If IsNull(Tables![tblMilitaryLeave]![DatePaid]) Then
stFilter = "Tables[tblMilitaryLeave]![DatePaid]"
End If

'Set the Filter property
Reports!rptMilitaryLeave.Filter = stFilter
Reports!rptMilitaryLeave.FilterOn = True

End Sub

I haven't tested this out...that jumped out at me as a possibility though.

* When you are trying to indicate a code block, put brackets [ ] around the word code and end it with brackets around /code.

[ChipR]

I think you want:
stFilter = "DatePaid IS NULL"

[DAHMB]

No niether of the above is correct, my problem is that it is a date field and the Is Null does not seem to work with it as formated. Is there a way to write it so that it works with a date field?

[ChipR]

If "#Tables![tblMilitaryLeav e]![DatePaid] ISNull#"

This doesn't make any sense as you are referring to an entire column of records. What are you trying to compare?

[DAHMB]

I have a form that adds filters to an open report. I want this one to show only records that have no value in the DatePaid field

and I tried "#Tables![tblMilitaryLeav e]![DatePaid] ISNull#" and I got a data type mismatch error.

[ChipR]

So you don't need the If condition at all. Just set the filter as in post #3 and apply it.

[DAHMB]

Thankyou That was it!!! ifeel dumb but I learned something, thanks again!

[NeoPa]

In case it helps Dan :
Tags are done as matching pairs where the opening one is surrounded by [...] and the closing one by [/...]. A set of buttons is available for ease of use in the Standard Editor (Not the Basic Editor). The one for the [ CODE ] tags has a hash (#) on it. You can choose which editor to use in your profile options (Look near the bottom of the page).

[DAHMB]

I don't understand what you mean here could you give me an example of my mistake?

[NeoPa]

I'm not sure Dan. The original was changed by Stewart days ago now, & I haven't kept the email notification. If memory serves correctly though, you were using <> instead of []. EG :
<code>
Your code here
</code>
As it might be if it were HTML (This uses BBCode by the way).

[Stewart Ross]

NeoPa's recollection matches mine, although I can't remember if it was angle brackets or none that had been used. You had actually marked the code segment clearly, either as

< CODE > ... < /CODE >

or simply

CODE ... /CODE

but in any event without using the brackets, so the delimiters didn't work.

-Stewart