Need Control Source to handle 2 Row Source for ListBox 1

[stlrain95]

I have a list box that displays 2 columns from a SQL row source.

Sample: SELECT CELL.Cell, CELL.Equipment FROM CELL GROUP BY CELL.Cell, CELL.Equipment;

When I select from the list box....I need both fields to display in the results box.

How would I go about doing this??

Thank you,

 

[TheAceMan1]

How are ya stlrain95 . . . . .

Be more specific!

See Ya! . . . . . .

 

[PHV]

Take a look at the ListBox.Column property and at the & concatenation operator.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TheAceMan1]

Haaaaaaaay [blue]PHV! . . . . .[/blue]

Before its too late:

Highest [purple]Respects![/purple] . . . . . [blue]Honor![/blue] . . . . .

and [green]Happy New Year! . . . . .[/green]

See Ya! . . . . . .

 

[stlrain95]

Alright, in the form I have a list box displaying 2 columns of information.

What I need is when I make a selection, I need both to show in the field.

Example:
Cell.Cell & Cell.Equipment show in drop down
But only Cell.Cell displays when selected.

 

[TheAceMan1]

OK stlrain95 . . . . .

It appears your talking a combobox from your last post (not a listbox), and specifically [purple]what shows in the TextBox portion[/purple] of the combobox . . .

Be aware, the textbox portion can only show a single column. In fact, its always the [blue]first non-zero width[/blue] in the [blue]Column Widths[/blue] property. So what you need to do is add a custom field with the concatenation to the [blue]RowSource[/blue]:

[blue]Sample:  SELECT [purple][b][Cell] & " " & [Equipment] as DspCell[/b][/purple], Cell, Equipment, FROM CELL GROUP BY CELL.Cell, CELL.Equipment;[/blue]

Increase the [purple]Column Count[/purple] property to 3 and make sure the new field (dspCell) is the [blue]1st non-zero width[/blue] in the [blue]Column Widths/b][/blue] property.

See Ya! . . . . . .

 

[stlrain95]

Awsome....working greatness

You get a star!!