473,394 Members | 1,829 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

How do I Make ComboBoxes Visible in Report Header

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!
Sep 20 '11 #1

✓ answered by RuralGuy

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

3 3094
RuralGuy
375 Expert 256MB
Reports are not interactive, they are basically a piece of paper. What are you trying to achieve.
Sep 22 '11 #2
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!
Sep 22 '11 #3
RuralGuy
375 Expert 256MB
Put the ComboBox on a *form* and Preview the Report from the FORM with a WhereClause.
Sep 22 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Tim Graichen | last post by:
I may have already asked this one, but, Is there anyway of hiding the dropdown control button on a combobox until the field has focus? Because the values in the combobox can be between 5...
0
by: Dalan | last post by:
The problem to resolve should be pretty easy for someone. I have a main form which contains a combo box to lookup various vendors. Have several reports for the vendors, but it is print all or...
1
by: Steve | last post by:
I have a button on a form that opens a report. I need to set the caption of several labels on the report equal to the value of a columns in comboboxes on the form something like: ...
5
by: Steve | last post by:
I have an unbound combobox in the form header of a continuous form. The selection in the combobox sets the where clause in a querydef which determines QryPFrmInventoryManagement. The following code...
2
by: Zlatko Matić | last post by:
I have several forms hierarchycaly nested in each other (form/subform/subform/subform....). The final form is "continous form", while parent forms are single forms through which navigation was...
8
by: Zlatko Matić | last post by:
There is a form (single form) and a combobox. I want that current record of the form is adjusted according to selected value in the combobox. Cuurrent record should be the same as the value in the...
3
by: Jimmy | last post by:
Is there a way to sort/group a report based on the second column of a combo box, i.e. the text associated with the primary key number?
1
by: billa856 | last post by:
Hi, I have one project in MS Access. In that I have one form in which I am using one combobox and one search button. Now when I select an item from that combobox and press the submit button then...
1
by: jmarcrum | last post by:
Hey everyone... I have a report with 4 labels on it at the top. The first label is lblSunday1, the second is lblSunday2, and so forth... I have a small form in my Database called frmReports. ...
2
by: JC2710 | last post by:
Hi I have a userform which has criteria entered into it from a combobox. It then runs a report from this form. I would like to display the text entered in combobox on the report. However I dont...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.