I've got to kids that leave jelly and other things on DVDs. So I wrote a simple program to store the movies in and they have access to them. All they have to do is click on the movie from a DBGrid1 which shows all the movies Click on a movie then Click on command Button 1 and movies starts.
My problem is I have some movies that are 2 or more disk long. To get program to go to next episode in that file without making another files for disk 2 The Command button has this in it.

Code:
Private Sub Command7_Click()
frmPlayMovie.Show
frmPlayMovie.Caption = Movies.MovieName.Text + " Playing Now "

frmPlayMovie.WindowsMediaPlayer1.URL = Movies.Category.Text
Note this is made for 6 and 7 year old kids. Made a screen shot attachment The movie picked is on 3 DVDs From kids view it has to be simple and un complicated. From my view it's just I am new at this. Not that much of an expert of doing things
Using Access mdb in VB6