combo boxes

[flygal5]

I've created a combo box w/2 columns. Col 1 has a code associated w/
description in Col2. Want to show these in 2 separate 'boxes' so if I select
a col 1 entry, the description automatically shows in another box. How do I
set up the properties in the 2nd box? Thanks for your help.

 

[Rick Brandt]

I've created a combo box w/2 columns. Col 1 has a code associated w/
description in Col2. Want to show these in 2 separate 'boxes' so if I
select a col 1 entry, the description automatically shows in another
box. How do I set up the properties in the 2nd box? Thanks for your
help.

This is not somethign you can do in a table. It can easily be done on a form by
having a TextBox next to the ComboBox that displays the second column with a
ControlSource of...

=ComboBoxName.Column(1)

(column numbers start with zero)