ok i have an application that is connected to an access database. It has two list boxes. i have got the first listbox to access the database and retrive movie titles with the following code:
VB Code:
Private Sub MovieApp_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load newMA = New MovieApp DsTitles.Clear() 'remove anything already in the dataset TitleAdapt.Fill(DsTitles) 'refill it IsInitialising = False End Sub
i now wish to for the user to be able to select a movie title from this list box and for the actors involved in the film to be displayed in a second list box. i created a new adapter and dataset to search for the actors in the selected film but i dont know where to go from here. ive messed around with the displaymember and value member and tried various code in else statement in the selected value changed but to no avail:
VB Code:
Private Sub lstFilmTitle_SelectedValueChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles lstFilmTitle.SelectedValueChanged If IsInitialising = True Then Exit Sub Else End If End Sub
any help would be appreciated, please treat me as a noob when it comes to handing databases and data binding as its all new to me.


Reply With Quote