i would like some help with this filter code

  • Thread starter Thread starter moshe via AccessMonster.com
  • Start date Start date
M

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
 
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.
Click to expand...

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]
 
Back
Top