ListBox/ComboBox Dynamic Datasource 1

[Auguy]

Is there a way to change the datasource of a ListBox or ComboBox dynamically. By that I mean having an array holding the names of a data tables like "dtUnitType", "dtModel", etc. Then setting the datasource to the value of one of the array items chosen by the user. I could use a case statement, but I'm trying to make this as dynamic as possible.

Auguy
Sylvania/Toledo Ohio

 

[jebenson]

Dim sTableNames() As String

'some code to fill the array with table names

ComboBox1.DisplayMember = "<Field Name to display>"
ComboBox1.ValueMember = "<Field Name to display>" 'this is optional
ComboBox1.DataSource = sTableNames(0) 'use the appropriate index here.

Given that you need to supply the DisplayMember (and optionally the ValueMember), you might want to include these items in the array as well.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[Auguy]

Thanks Matey!
I wasn't sure if the datasource would allow assignments like that.
Yes I will include those other items in the array.
I'm hoping to build a fairly generic filter generator so I don't have to add a control to the filter form for every filter condition, I can just add it to a table for the source of the array.

Because it's coming soon, let me be the first to say happy "Talk Like a Pirate Day"

Auguy
Sylvania/Toledo Ohio