Controls not showing up in reports...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a report that is based on a parameter query, and when I
go to run the report my combo box that is populated with a list of company
names to be searched upon disappears but the label remains. Any ideas?

Also, in my parameter query, for the parameter, I have my Form syntax as such:

Forms!ReportName!ComboBoxName

In this is is this correct syntax?
 
I am confused ...

The subject line mentioned Controls on Reports but in the body of the post,
you described the disappearance of the ComboBox on the Form???

This is probably why you haven't got any response so far. Remember if
potential respondents have to guess what the problem is, they are more
likely to select not to respond instead.

Please repost describe your set-up (including OS & Access versions) and the
problem clearly and succinctly.
 
Basically, when I'm trying to do is put a combo box on to a report so that
the user can filter out the records that he or she wants from the query.
When I put the combo box in the Report Header and run the Report all I am
able to see is the label of the combo box and the unfiltered report. I guess
my question is can a report be filtered by the contents of a combo box? If
so, how?
 
Reports are meant to be printed or previewed on screen, NOT interactive.
You cannot filter a Report with a ComboBox on the Report!

Put it this way, I never used ComboBox on Reports.

It sound to me that you should use a ComboBox on a "PreReport" Form with a
CommandButton to print / preview the Report. In this case, you can use a
Parametrised Query using the ComboBox on the "PreReport" Form as the
Parameter to filter the Records (for the Report) as required.
 
Back
Top