Combo Box on Form putting numbers not names in main table

S

SarahJ

I have combo boxes on my forms with names for distribution. In the wizard I
told it to put what I select in the main table however it is putting the
numbers and not the names from the distribution table.

I have the names displayed in the form. I want them to translate to the
main table so I can run reports.

ANY HELP???
 
B

Beetle

Hi Sarah
In the wizard I told it to put what I select in the main table however it is putting the numbers and not the names from the distribution table.
Click to expand...

If you mean that numbers are showing up in the combo boxes, then do this;

Open your form in design view, open the properties sheet for your combo box,
and go to the Format tab. You will see properties for "Column Count" and
"Column Width". Set the column count to 2 (or however many you need) and
column widths to 0";2" (add additional width criteria if you have more than
two columns). This will hide the first column that contains the numbers
(probably your primary key) and display the second column that contains the
name.

If I misunderstood your question then post back.

HTH
 
J

John W. Vinson

I have combo boxes on my forms with names for distribution. In the wizard I
told it to put what I select in the main table however it is putting the
numbers and not the names from the distribution table.

I have the names displayed in the form. I want them to translate to the
main table so I can run reports.

ANY HELP???
Click to expand...

The table SHOULD contain numbers. That's exactly what the combo box wizard
does.

Base your report, not on the Table, but on a Query joining your table to the
lookup table (or tables). That's how relational databases *work* - pulling
data together from multiple tables! If you are assuming that all the data must
be in the same table in order to create a report, revise your assumption.

John W. Vinson [MVP]
 
Top