combo box display

Is there a way to set up a combo box so that when the user clicks the arrow,
the list is populated with info from a specific field from a table but once
they select an option, data from another field gets displayed in the box? In
other words, when the user selects the drop down list, I want a them to see
a list of full titles for them to select. Once they click on a title,
however, I want an abbreviation to get put into or displayed in the box. So
a record in the table might read:

ID Title Abbreviation
1 A Full Title Is Here Full Title

So, user opens the list box and sees "A Full Title Is Here", they click on
that text and "Full Title" appears in the closed combo box.


.

Relevant Pages

  • Re: Sub returning reference
    ... syntactic sugar makes it so. ... But that's an abbreviation for ... > No, the arrow is optional between bracket subscripts, so ...
    (comp.lang.perl.misc)
  • Re: Filter : sort of urgent
    ... Click the "down arrow" in the Titles column, and choose "Custom". ... words "game theory" in them. ...
    (microsoft.public.excel)