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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top