values in form displaying as numbers instead of list items

[e18cincy]

In Access 07, I have a list box in which I display values from a table, call it tblTable1. One value in tblTable1 is limited to a combo box showing acceptable values from tblTable2. In the list box on the form, however, I only get the numbers of the items instead of their values. I assume this is because I am pulling from a table that doesn't house the actual values. What's the best way to rectify this issue and show the actual values (such as "Chrysler" or "Ford" instead of 1, 2, etc...)? I am hoping to do it while still limiting user input in the table to the list of values, so that I'm not stuck dealing with input error issues.

Thanks,

E

 

[xenou]

Usually, this can be accomplished by creating a combobox that has two columns. Turning on the wizard and adding a combo control takes you through the steps, but the main points are:

1) Row Source Type is Table/Query
2) Row source for the combo box is your Query (with two fields, in this case)
3) Columns should be set to 2
4) Bound column should be set to 1 (the column with ID numbers)
5) Column width should be 0;3 (or something like that - zero inches for first column, meaning hidden, and 3 inches, more or less, for the second column, meaning what the user sees).
6) Since bound column is column 1, the real value of the box is the ID number. But what the user sees is the associated Text description, name, or what have you.

A pretty good tutorial I think is here:
http://fisher.osu.edu/~muhanna_1/837/MSAccess/tutorials/combo.pdf

Alex