Query on value of combo box

[Kathy Petrucci]

I created a database for tracking all movies that I've
watched. The main table has all of the info - title,
stars, genre, rating, etc. I also have a table with just
the 16 different genres which I used for a combo box on a
form so that a user can select only the movies in a
certain genre without having to type in the genre. The
combo box opens a form from a query but I can't figure
out how to make that query only open the records based on
what I select in the combo box. Or maybe I need to add
something to the Visual Basic code that opens the form?

 

[JL]

You are on the right track.

You have to put the code.

DoCmd.OpenForm "FormName"

to actually make the form open.
Hope this helps.