combobox.selectedvalue problem

[Guest]

Hello,

I have a combobox populated by a dataset filled with data from a SQL view.
In the view I have combined two fields to create one.
I can't set my combobox.selectedvalue to this value. Any other field in the
view works, but this one leaves the combobox empty...

The purpose behind this is to display what the user is to select, along with
a description of each item.

Any suggestions?
Thanks in advance,
Amber

 

[Guest]

Amber,
Try aliasing the combined fields in the SQL statement. For example:
"select (Fname || '-' || Lname) as Name from myTable"

You can then reference the combined fileds as follows in the combobox as
follows:

combobox.selectedvalue="Name"

Hope this helps,
Rich

 

[Guest]

Hi.
Thanks for the reply.
That's exactly what I have done.

Me.cboSeason.DisplayMember = "DisplayDesc"

Where

DisplayDesc is alias for:
STR_DISPLAY_VALUE + ' ' + STR_VALUE_DESC

Amber