Filter on top of form?

From: Mike (anonymous_at_discussions.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 13:05:53 -0700

Hello,

I saw an access form and the top of the form was a filter
for the data below. For example if you put MI in the
state filter it would give you only the MI records. If
you then put Lansing in the City filter, it would filter
for both Lansing and MI. If they were all blank, all
records were shown.

It would be VERY helpful if I could do that. I tried a
subform to make as a filter but when I put it in the
header it wouldn't allow continuous forms. Even if it
did, I am not sure that I could have made it work.

Any ideas?

Mike