filter buttons

[emoskalik]

I have a contacts form with buttons that filter the form by last name.
The buttons code looks like this (a different button for each letter
in the alphabet)

DoCmd.ApplyFilter "", "[LastName] Like ""[J]*"""

This works great but now I want to do the same thing but with the
FirstName field. My problem is that when i click on my new filter
button my previous filter for the LastName gets cleared. How can i
have my second filter apply to the filtered results of my first filter
using a button?
Thanks!

[Fred Zuckerman]

<em*******@gmail.comwrote in message
news:11**********************@k79g2000hse.googlegr oups.com...

>I have a contacts form with buttons that filter the form by last name.
The buttons code looks like this (a different button for each letter
in the alphabet)

DoCmd.ApplyFilter "", "[LastName] Like ""[J]*"""

This works great but now I want to do the same thing but with the
FirstName field. My problem is that when i click on my new filter
button my previous filter for the LastName gets cleared. How can i
have my second filter apply to the filtered results of my first filter
using a button?
Thanks!

Try:

Me.Filter = Me.Filter & " And [FirstName] Like ""T"""
Me.FilterOn = True

I usually use the Me.Filter and the Me.FilterOn properties, instead of
DoCmd.ApplyFilter. I don't know the difference.

Fred Zuckerman

[Tom van Stiphout]

On Tue, 25 Sep 2007 05:39:44 -0700, "Fred Zuckerman"
<Zu********@sbcglobal.netwrote:

Just put an * after the T
-Tom.

><em*******@gmail.comwrote in message
news:11**********************@k79g2000hse.googleg roups.com...

>>I have a contacts form with buttons that filter the form by last name.
The buttons code looks like this (a different button for each letter
in the alphabet)

DoCmd.ApplyFilter "", "[LastName] Like ""[J]*"""

This works great but now I want to do the same thing but with the
FirstName field. My problem is that when i click on my new filter
button my previous filter for the LastName gets cleared. How can i
have my second filter apply to the filtered results of my first filter
using a button?
Thanks!

Try:

Me.Filter = Me.Filter & " And [FirstName] Like ""T"""
Me.FilterOn = True

I usually use the Me.Filter and the Me.FilterOn properties, instead of
DoCmd.ApplyFilter. I don't know the difference.

Fred Zuckerman

[Fred Zuckerman]

Oops, thanx Tom.

"Tom van Stiphout" <no*************@cox.netwrote in message
news:ji********************************@4ax.com...

On Tue, 25 Sep 2007 05:39:44 -0700, "Fred Zuckerman"
<Zu********@sbcglobal.netwrote:

Just put an * after the T
-Tom.

>><em*******@gmail.comwrote in message
news:11**********************@k79g2000hse.google groups.com...

>>>I have a contacts form with buttons that filter the form by last name.
The buttons code looks like this (a different button for each letter
in the alphabet)

DoCmd.ApplyFilter "", "[LastName] Like ""[J]*"""

This works great but now I want to do the same thing but with the
FirstName field. My problem is that when i click on my new filter
button my previous filter for the LastName gets cleared. How can i
have my second filter apply to the filtered results of my first filter
using a button?
Thanks!

Try:

Me.Filter = Me.Filter & " And [FirstName] Like ""T"""
Me.FilterOn = True

I usually use the Me.Filter and the Me.FilterOn properties, instead of
DoCmd.ApplyFilter. I don't know the difference.

Fred Zuckerman