Combo Box displays incorrect selection

  • Thread starter Thread starter Chuck
  • Start date Start date
C

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.
 
YOU CAN MAKE IT BOUND BY A UNIQUE VALUE IN THE TABLES
FIELD AND REFER TO YOUR NUMBERS USING THE .COLUMN PROPERTY
 
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
 
Back
Top