Combo Box in a Report

[Moxioron]

Hello all.

I am pulling my hair out trying to figure out how I can add a combo box that can be used to filter a report.

I know in the query that is tied to the report I can use Like [Mgr Name]&"*" and if you know the Mgr Name exactly it works great.

However, there are hundreds of Managers and I would love to have the user select from a drop down list. I already created a form and as long as I have that form open, it works....but that is not ideal.

I want the user to select the report on the Switchboard manager, put in the date ranges, which works great, and select the Manager Name from a drop down list.

Why is there a toolbox toolbar with a comb box option in Reports if it doesn't do anything?

Anyway, an easy way to get a combo box to work in a report without complicated VB code? Thanks for your help.

 

[Montez659]

You won't be able to use a combobox in the report the way that you want to. Any controls in reports are non-selectable. The purpose of the combobox in the report is so that you can set the recordsource of it to a table or query to fill the correct name.

For instance the contactID of someone in my contact table is what would show. Set the combobox record source to tblContacts and display the second column only (first col is the contactID, second is name) then the name will display.

So, that said, your best bet is to filter PRIOR to running the report. Put the drop down on a form as a final selection. I have done this, and included an option to show all managers, works like a charm. An extra step? Yes, but I don't think there is any other way around it.

 

[HiTechCoach]

I recommend using a form to collect the criteria.

See: Report Dialog Examples

Hello all.
Why is there a toolbox toolbar with a comb box option in Reports if it doesn't do anything?

The do work on reports. Just not for data entry. They can be used to look up data in a related table. I find it better to just all the look up table to teh report's record source.