Filtering a subform ( command button )

[John Smith]

Hi:

I am using Access 2003 and have a form ( Form00 ) that is just plain old
blank. On that form I have a subform ( Form99 ) that lists the required
information from a query. What I really need to speed things up is about 10
filters. What would be perfect would be 10 command buttons each with there
own filter. This way, I can hit the command filter and get the records
quick and easy. Problem is that I can't get it to work for the subform.

Can anyone help me with this please.


TIA

 

[Steve]

Consider doing it this way ----

Base Form99 on a query. Look up QueryDef in the Help file. QueryDef will
allow you to modify the Where clause of your query anyway you want. You set
up an unbound option group on your form with ten options for the ten subsets
of data you want to produce. Then use a Select Case routine in the Option
Group's AfterUpdate event to modify the Where clause in the query's SQL
according to the option that is selected.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)