Filter values in a form by clicking

  • Thread starter Thread starter Aya via AccessMonster.com
  • Start date Start date
A

Aya via AccessMonster.com

Hi, I'm creating a database using Access 2000.

I have a form named Department and shows a lists of departments that are
showed in a List Box.

Let's explain it as an example:

I have Department 1, 2 and 3 in the List Box. I want the user to select the
department of their preference. Then when they click on the OK button, I want
the Tasks table to be filtered automatically and show only the title of the
tasks that are in the selected department.

I think that I need some coding to make this work and I'm not sure how to do
it. Any help and suggestions will be appreciated. Thanx.
 
Another thing, when they click on OK, it will send them to a new form, which
I want the filtered tasks of the selected department to be shown in this new
form on the List Box.

To review: one form will have the name of the Departments, they select one
and with a click a new form opens. The form with the filtered Tasks of the
selected department in the Tasks form.

Any help, I'll appreciate it very much. Thanx
 
Back
Top