filter a recordset

[spinkung]

Hi

i am trying to filter a recordset but it doesn't seem to be working.

The forms recordset has 3 rows. One of the fields is a status flag. I want to only show the rows in my recordset where the StatusFlag is empty ("").

I use the filter but when i do a row count i still get 3 rows

        Set rs = srcForm.Recordset
        rs.Filter = "StatusFlag = """""
        MsgBox rs.RecordCount

can anone tell me what im doing wrong

thanks

 

[spikepl]

Is it empty, as in nothing was entered, or was a 0-length string "" inserted by user or by default?

 

[spinkung]

Hi

the field is typed by the user from 'H' to ''. so 0 length string??

Thanks

 

[spikepl]

rs.Filter = "StatusFlag = ''"

or

rs.Filter="StatusFlag Is Null" , since I am still not sure where the value comes from

 

[Galaxiom]

How about:
rs.Filter= "Len(StatusFlag & vbNullString)=0"

Though if it is a flag why not use a Boolean field?

 

[spikepl]

#5 Of course *beating head against screen*

 

[Galaxiom]

#5 Of course *beating head against screen*

There shoud be an emoticon for "beating head against screen". We all need it sometimes.