asked on

populate combo box from dataset

Hi,
Please help with the code below, i have a dataset and i need to filter on 1 of the tables for certain values and then popultae my combo box
here is the code i am using but i am getting the following error
"Cannot bind to the new display member"
ItemName is my field in teh Dataset

'This is for the combo box on the SCI Users pannel
drows = SPds.Tables("lstLookupList").Select("Category = 'SCIUsersStatus'") '
With frmMain.cmbSCIUsersStatus
.DataSource = drows
.DisplayMember = "DisplayField"
.ValueMember = "ItemName"
End With

thanks

Éric Moreau

Do you have a field name DisplayField in your datatable?

CraigLazar

ASKER

Hi
i checked that after i posted the code sorry
'This is for the combo box on the SCI Users pannel
drows = SPds.Tables("lstLookupList").Select("Category = 'SCIUsersStatus'") '
With frmMain.cmbSCIUsersStatus
.DataSource = drows
.DisplayMember = "ItemName"
.ValueMember = "ItemID"
End With

still same error

Éric Moreau

are you sure that ItemName and ItemID are columns in SPds.Tables("lstLookupList")?

ASKER CERTIFIED SOLUTION