See
http://www.emoreau.com/Entries/Articles/2007/01/Setting-a-master_2fdetail-relationship-between-two-ComboBox.aspx>I have a form with two drop down combo boxes.
>
>The first one is a list of People that is populated based off a simple view,
>the Datasource=ViewPersonsWithDocumentsBindingSource, the Value Member is set to PersonID
>
>When a person is selected in the first drop down, I want to populate the second drop down based off the value member in the first drop down.
>
>The second one is a list of documents available based off the person selected in the first combo box, and there is a stored procedure for that one and it requires a parameter which should be the personID.
>The datasource=ctLuDocumentsByPersonIDBindingSource
>
>The form runs, but of course the second combobox doesn't populate because the parameter is not set to anything. I'm assuming that in the ComboBox1_SelectedIndexChanged method, I need to put some code to set the parameter and refresh the datasource. I just don't know how to do that. I'm using vb.net
>
>Any pointers?
>
>Thanks
>Kirk
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com