Beginners Help

Hi

I have been asked at work to build a simple(!) database. The databse is to hold personnel information and consists of several columns including:
Dept. Name. Position. Salary. Start Date.

I have created all the information on one table.

What they need is a form with a drop down combo box listing the depts. They also want a button that when clicked will produce a report with the information pertaining to the chosen department.

I have created several queries from the table, filtering by department and their respective reports. I have also created a query from the table that only contains the departments which I have grouped but I am having trouble getting the form to work. I cannot get the combo box and button "talking" to each other. They seem to work independantly of each other. When I place the print button on the form it asks me which report I want to link to. I don't want to link to any report, I want the combo box to determin which report to link to.

Can anyone help.

Thanks
Andrew