Hi Jean-Paul,

not sure if it makes a difference because I never switch them... but I
always put Me.FilterOn = True AFTER I set the filter...

"Patienten.[kineitem] = false AND Patienten.[Nu nog leerling] = 'J'"
should be ok -- I removed the space after the last single quote '

if kineitem is not in the form RecordSource twice, you should not need
to preface it with the tablename... same with [Nu nog leerling] ... so
you should be able to do this too:

"[kineitem] = false AND [Nu nog leerling] = 'J'"

It is a bad idea to use spaces in names. For the future, I recommend
you not do it.

to help you understand Access a bit better, send me an email and request
my 30-page Word document on Access Basics (for Programming) -- it
doesn't cover VBA, but prepares you for it because it covers essentials
in Access.

Be sure to put "Access Basics" in the subject line so that I see your
message...


Warm Regards,
Crystal
*
(: have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Jean-Paul wrote:
Hey....
I wrote:

Private Sub Form_Load()
Me.FilterOn = True
If ALleofNu = "N" Then
Me.Filter = "Patienten.[kineitem] = false"
Me.filteron = True
endif
End Sub

with perfect result...
But when I canhed it all into:

Private Sub Form_Load()
Me.FilterOn = True
If ALleofNu = "N" Then
Me.Filter = "Patienten.[kineitem] = false"
Else
Me.Filter = "Patienten.[kineitem] = false AND Patienten.[Nu nog
leerling] = 'J' "
End If
End Sub

I get an errormessage 2001 (no help available) saying (and now I have to
translet so the syntax may be different)
"You dismissed previous action"

What do I do wrong this time?
Also I doubt if the syntax
"Patienten.[kineitem] = false AND Patienten.[Nu nog leerling] = 'J' "
will work because of the quotes ('J' ")

Thanks fo your kind help and best wishes for 2007
JP Belgium

strive4peace schreef:
Hi Jean-Paul,

if you are filling the property in directly for Filter, do not use quotes

Also, there is no FilterOn property in the property sheet...

a suggestion:
put spaces on either side of your operator
kineitemtrue -- kineitem true

Is kineitem defined to be Yes/No? Is kineitem in the form RecordSet?

Warm Regards,
Crystal
*
(: have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Jean-Paul wrote:
I did that in the properties of the form itself... not in the Load-event
I don't think this should make any difference, but it still doesn't
work!!
strange
JP

strive4peace schreef:
Hi Jean-Paul,

in addition to *Filter* forms also have a *FilterOn* property

you can do this on the form Load event...

'~~~~~~~~~~~~~~~~~
me.Filter = "kineitem true"
me.FilterOn = true
'~~~~~~~~~~~~~~~~~

Warm Regards,
Crystal
*
(: have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Jean-Paul wrote:
Hi,
My form is based upon a table (of course...)
In the properties I set "kineitemtrue" as filter
filter is set to true

When I "walk" through my records, I see all records, even those
with "kineitems = true"

What can cause this?

Thanks
JP