Filter values in form

[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.

 

[Aya via AccessMonster.com]

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