filter not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hey all,

i have a simple form and i'm trying to specify a filter in the properties
[CompletedDate] IS NULL and for some reason it's not working. Can someone
please tell me what I might be doing wrong?

thanks,
rodchar
 
hey all,

i have a simple form and i'm trying to specify a filter in the properties
[CompletedDate] IS NULL and for some reason it's not working. Can someone
please tell me what I might be doing wrong?

thanks,
rodchar
Click to expand...

You must then apply the filter.
Using code:
Me.FilterOn = True

to remove it
Me.FilterOn = False

Or..
Using the mouse, right-click on the form and select
Apply Filter/Sort

to remove the filter
Remove Filter/Sort

and of course the forms's Allow Filters property must be set to Yes.
 
Try and put in the Load event of the form the code

Me.Filter = "[CompletedDate] IS NULL"
Me.FilterOn=True

see what happen
 
yes, its default was yes.

Ofer said:
Have you changed the AllowFilters property to Yes?

--
I hope that helped
Good Luck


rodchar said:
hey all,

i have a simple form and i'm trying to specify a filter in the properties
[CompletedDate] IS NULL and for some reason it's not working. Can someone
please tell me what I might be doing wrong?

thanks,
rodchar
Click to expand...
Click to expand...
 
That worked. Thanks everyone for the great feedback.

Ofer said:
Try and put in the Load event of the form the code

Me.Filter = "[CompletedDate] IS NULL"
Me.FilterOn=True

see what happen

--
I hope that helped
Good Luck


rodchar said:
hey all,

i have a simple form and i'm trying to specify a filter in the properties
[CompletedDate] IS NULL and for some reason it's not working. Can someone
please tell me what I might be doing wrong?

thanks,
rodchar
Click to expand...
Click to expand...
 
Back
Top