How do I Make ComboBoxes Visible in Report Header

[clintonf]

Hey all,

Apparently this isn't as obvious as I thought in Access 2007.

In my report's design view I added a combobox to the Report Header area. The combobox is filled via a query and I used the default options for the rest of wizard that pops up when you create a combobox.

The problem is: the combobox isn't visible!

Under the properties

• enabled = yes
• column count = 2 (default)
• everything else = default

I tried moving the combobox to the page header and the detail section but it's still not visible.

I'm not sure what I'm missing here.

Any ideas?

Thanks!

[RuralGuy]

Reports are not interactive, they are basically a piece of paper. What are you trying to achieve.

[clintonf]

I'm looking at attendance data, in 6 classes, for each month. I want to use the combobox to output one month of attendance data at a time and move back and forth between months.

Thanks!

[RuralGuy]

Put the ComboBox on a *form* and Preview the Report from the FORM with a WhereClause.