Report shows ALL entries in the combo box...

[TJones76]

Hi there...

I have a problem with my report, which is based on a table:
The combo box field in the report shows all of the combo box entries.. instead of just showing the selected value. My table shows only the selected value for that field, why isn't my report showing the same??

Thanks for your help
Tiffany



-Tjones76

 

[dhookom]

There is no way that a combo box in a report will ever show more than one value.

Do you have a combo box on a form that you want to filter the records returned in a report? If so, come back with some form, control, report, and field names.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[TJones76]

Yes, it's a drop down list (table field is based on another table of names) on my Form that when I select a name it populates the field, i checked my main Table that the form is tied to to make sure that it's showing the name that I've selected.. and it does. But for some reason the Report (which is based on the Table) shows ALL names in the list box and Highlights the one that was selected. It will not show just the one name that appears in the table's field.



-Tjones76

 

[dhookom]

Is there a reason why you are using a list box on a report? You should use a text box. This assumes that the text value you want to display is included in the report's record source.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.