Filter a report using a combo box

Question

I have been trying to filter a report using a combo box on a form and have had little success.  The combo box is pulling from a table that just contains manager name data and the report is pulling from a table that contains manager names as well as many other fields.  I have attempted to use the Where Condition in the macro tools as well as Apply Filter and any other option I could find that looked like it might work.  I know this has to be something easy, but I have been unable to find anything that gives me instructions or code on how to do this.  Thanks in advance for any assistance.

Answer 1

Does the table you're using in the report contain the manager name, or a numeric manager ID (perhaps concealed from your view by Microsoft's infuriating Lookup Field misfeature)? Please post the RowSource property of the combo and the Recordsource of the Report - my guess is that you need a numeric ID.

Answer 2

No, the combo box doesn't have to be based on the same table, but its bound column should correspond to the manager name field. What is the Column Count of your combo box? If it is 2, the actual bound column may not be the manager name.

Answer 3

I have tried that about 10 times with no luck.. Does the combo box have to be based on the same table as the report/query?

Answer 4

Enter the following in the Where Condition of the OpenReport action:

[Manager Name]=[Forms]![NameOfForm]![NameOfComboBox]

substituting the correct names of course.

Answer 5

create a query with criteria(this is where in a query SQL) as the combo box.