Query on value of combo box

  • Thread starter Thread starter Kathy Petrucci
  • Start date Start date
K

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?
 
You are on the right track.

You have to put the code.

DoCmd.OpenForm "FormName"

to actually make the form open.
Hope this helps.
 
Back
Top