If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Silly questions about reports and comboboxes
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! |
#2
|
|||
|
|||
Silly questions about reports and comboboxes
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. -- Duane Hookom Microsoft Access MVP "Kimberly3626" wrote: 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! |
#3
|
|||
|
|||
Silly questions about reports and comboboxes
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. -- Duane Hookom Microsoft Access MVP "Kimberly3626" wrote: 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! |
#4
|
|||
|
|||
Silly questions about reports and comboboxes
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. -- Duane Hookom Microsoft Access MVP "Kimberly3626" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|