Silly questions about reports and comboboxes

K

Kimberly3626

Hi all. I know I'll feel really silly when the answer is posted but...

I have a report. I tried it two different ways.
1. Based on a query of given tables
2. Based on the tables themselves. (not too much data, no need for anything
elaborate)

Here's my problem: My tables look up information in a third table to create
a dropdown menu. When I run my report, it is showing EVERY item that is
available in the dropdown (complete with the scrollbar!!!)
How do I make it put in the selection. It's currently highlighted in the
dropdown as displayed on the report, but this is one ugly report!
 
D

Duane Hookom

You add the table from your List Box (or Combo Box) to the Record Source of
your report. This will "expose" the actual field with the value you want to
display in your report. Use a text box to display the value.

You might want some light reading on the evils of lookup fields defined in
tables http://www.mvps.org/access/lookupfields.htm.
 
Top