Combo Box displays incorrect selection

[Chuck]

I know there is probably a simple answer to this....

I have a simple form, displaying 12 combo boxes that select data from 12
tables. Each table has a name and a value from 1 to 50. There can be more
than one number of equal values. So Tom, Mary and Jane may all have a value
of 3 from the same table. Anyways, I have the combo box set up to display
the name and not the value, but its bound to the value so I can do some
simple math with the numbers. When I select, lets say Mary ( a value of 3),
it displays Tom (the first in the list of "3" values). I need it to display
Mary for reporting purposes. What am I missing to keep the combo box set to
Mary? Thanks.

 

[RI]

YOU CAN MAKE IT BOUND BY A UNIQUE VALUE IN THE TABLES
FIELD AND REFER TO YOUR NUMBERS USING THE .COLUMN PROPERTY

 

[Jeffrey K. Ries]

Goto the properties of the combo box and goto the 'Data' tab. Under 'Row
Source' select the '...' button next to the field to build a query. The
query should display the correct table at the top; simply dbl-click the
field which you would like displayed in the combo box. This will move it to
the front of the line.

This may not be the best solution, however I am quite new to Access and I am
just stumbling around myself. This is the method I have used many times to
solve the same problem you are having.

Good luck and I hope this helps,
Jeffrey K. Ries