Opening record based on subform selection

[darkmage1]

I would like to be able to select and item on my subform which is attached to my main form and automatically open up that record on another form.

For example I have a dvd collection that has a form named Actors. In the Actors form I have a subform that lists all of the movies that this actor is in. I would like to be able to select a movie from the subform and have that particular record displayed on another form.

 

[PHV]

Have a look at the 4th argument of the DoCmd.OpenForm method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886