combobox.selectedvalue problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top