display multi columns after combo box selection

  • Thread starter Thread starter Silvio
  • Start date Start date
S

Silvio

Hello Experts!

I have a 2 column combo box based on a table.

Before a user makes a selection, all 2 columns are displayed.

After a user makes a selection, only 1 column is displayed.

Is there a way to have all 2 columns displayed AFTER the user makes a
selection?
 
No, there isn't.

If you need all the information, you either need to concatenate everything
into one column for display purposes, or else write the information from the
additional columns into text boxes on the form.
 
Concatenate will wok too. Thank you Douglas.

Douglas J. Steele said:
No, there isn't.

If you need all the information, you either need to concatenate everything
into one column for display purposes, or else write the information from the
additional columns into text boxes on the form.
Click to expand...
 
Not in the combo box itself, but you can add an unbound text box right next
to the combo, and make it's control source;

=[YourCombo].Column(x)

where x is the numeric position of the column you want to display. It's a
zero based index, so the first column is Column(0), second is Column(1)
etc.
 
Back
Top