i would like some help with this filter code

[moshe via AccessMonster.com]

Hi everybody.
I have the following code that should add a filter to my form, the filter
string is exactly as I want it to be, but it only shows 3 records from about
110 that matches this criteria, I don't see any difference between those
records and the rest of my database.

Sub GetCriteria()
Dim FilterCriteria
FilterCriteria = " proposed <> 'previous' And apartmentsearchid = 0 And
inactive = false"
If Not IsNull(Me!FromRoom) Then FilterCriteria = FilterCriteria & " and
rooms >= " & Me!FromRoom
If Not IsNull(Me!ThruRoom) Then FilterCriteria = FilterCriteria & " and
rooms <=" & Me!ThruRoom
If Not IsNull(Me!TypeSearch) Then FilterCriteria = FilterCriteria & "
and type ='" & Me!TypeSearch & "'"
If Not IsNull(Me!SaleRentSearch) Then FilterCriteria = FilterCriteria &
" and salerent='" & Me!SaleRentSearch & "'"
Me.Filter = FilterCriteria
Me.FilterOn = True
End Sub

my problam is with the "" proposed <> 'previous' "" i have also tried ""
not propposed = 'previous' "" and i have the same problem but i removed that

line it wrks perfect but i need to take ddown those what proposed is =
previous.
Please reply thanks in advance

 

[John W. Vinson]

Hi everybody.
I have the following code that should add a filter to my form, the filter
string is exactly as I want it to be, but it only shows 3 records from about
110 that matches this criteria, I don't see any difference between those
records and the rest of my database.

Answered (with a request for clarification) in microsoft.public.access.

Please don't multipost. If you need to ask a question in several newsgroups
(note that it's rarely necessary, most of the volunteers read multiple
groups), please crosspost to all groups simultaneously rather than separate
posts to each newsgroup. This will let the volunteers see which posts have
already been answered.

John W. Vinson [MVP]