Apply Filter

[Jose Perdigao]

I would like to filter using docmd.ApplyFilter in a form typing part of the
text.
This criteria in a queries I use like "*parteofeNem*".

How can I use this criteria using code) (docmd.ApplyFilter, ...)

Thanks,
José Perdigão

 

[Guest]

You need to use Like and to include the field you're comparing, eg:

DoCmd.ApplyFilter , "[Surname] Like 'S*'"

 

[Jose Perdigao]

I tried before, it din't work. Now it works, I don't know what I did wrong,
but now it works fine,

Thanks,
jose perdigao

You need to use Like and to include the field you're comparing, eg:

DoCmd.ApplyFilter , "[Surname] Like 'S*'"

I would like to filter using docmd.ApplyFilter in a form typing part of
the
text.
This criteria in a queries I use like "*parteofeNem*".

How can I use this criteria using code) (docmd.ApplyFilter, ...)

Thanks,
José Perdigão