Pull Valuemembr from combo to populate another combo

[Lenvdb]

Hi gurus
I have 3 combos. There are 3 related Lookup tables in my DB that populate each.
The top is loaded at Form Load level. I then select an item in the top that must lookup the ID and populate the second combo with all items in the second Lookup table. I must then select an item in the second combo. This will lookup an ID and populate the 3rd combo with all items in the 3rd Lookup table have the same foreign key.

I keep getting an error :
"Cast from type Datarowview to type String is not valid"
I use datasets to populate these lists and bind the valuemembers to the IDs and the Displaymembers to the Items in the List. I set its Datasource properties.

How does one kill this error?

Len

 

[bueller]

Lenvdb,

I do not know if this will help you greatly but a suggestion would be to just get the text of the first one by simply doing lstrtest = Me.cmbOLCarrier.Text

Then repeat this on down the line. or is this what you are doing and it is not working?
HTH,
bueller