Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

ComboBox derived from 2 datasources

I have a Input ComboBox with the list bound to a sql binding source "bsStaffList" and I want to retreive and save the value from and to the customer binding source bsCustomerDetails - StaffID

Cant seem to work out how to do that. I['ve tried a few combo-nations :) no sucess so far.

Also tried values in  SelectedIndeax and SelectedValue with no sucess.

Can anyone help ?


Me.ipCbCSO.DataSource = "bsStaffList"
        Me.ipCbCSO.DisplayMember = "name"
        Me.ipCbCSO.ValueMember = "bsCustomerDetails - StaffID"  <<- ????

Open in new window

0
siacom
Asked:
siacom
  • 2
  • 2
1 Solution
 
jpaulinoCommented:
You cannot do that way!
You have do define the DisplayMember and ValueMember for the DataSource you have defined and not another one.
0
 
siacomAuthor Commented:
so you cant use 2 datasources ? 1 for dispolay and 1 for value ?
0
 
jpaulinoCommented:
No, you have to join the information in only one datasource
0
 
siacomAuthor Commented:
hmmm.... not something I want to do right now... might as well not have a combo.
thanks anyway.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now