Filtering a subform ( command button )

  • Thread starter Thread starter John Smith
  • Start date Start date
J

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
 
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)
 
Steve said:
Consider doing it this way ----
Click to expand...

Consider stopping advertising...
-
Hey Steve!! We don't need you here !!
Hey Steve!! We don't want you here !!

This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html (updated, mainly the 'abuse-reporting' page...)
Until now 4150+ pageloads, 2600+ first-time visitors
(these figures are real and rapidly increasing)

Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.

It is not relevant whether he advertised in *this* particular post or not...
==> We want him to know that these groups are *not* his private hunting grounds!

For those who don't like too see all these messages:
==> Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.

ArnoR
 
Back
Top