Query - Look up one value, show another, input look up value

[Guest]

Here is what I am trying to do. I would like to create a combo box in a form
that drops down with a list of states. I have created a table that has both
state name and state abbreviation (Illinois in one column, IL in the second
column). I would like to have the dropdown box show the user "Illinois" but
once Illinois is clicked to input "IL" into the field. Is it possible to do
this without VBA?

 

[Marshall Barton]

Here is what I am trying to do. I would like to create a combo box in a form
that drops down with a list of states. I have created a table that has both
state name and state abbreviation (Illinois in one column, IL in the second
column). I would like to have the dropdown box show the user "Illinois" but
once Illinois is clicked to input "IL" into the field. Is it possible to do
this without VBA?

Simple, just set the combo box's BoundColumn property to 2
and the ColumnWidths to 1;0