dropdown filter on Data Access Page

[Chris]

Hi,
I have a data access page that is based on a query in my database.

Currently the page brings up all data for today, and the page is formated
into teams

So it looks like this

Today's date
Team #1
entry #1
entry #2
Team #2
entry #1

Since this page can get long sometimes, I would like to add a dropdown menu
at the top of the page, that allows them to filter their results by team.

So once they make a selection they would only see the team selected.

Today's date
Team (only 1 listed)
Entry #1
Entry #2

I've been trying to search on this, but just can't seem to find the right
answer.

 

[Ken Snell \(MVP\)]

I have a sample database that lets you set a filtering value and then show
the filtered results in a new DAP:
http://www.cadellsoftware.org/SampleDBs.htm#FilterDAP

It may be a starting point for you.