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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query combo box 1
Starting a query using a drop down list box 2
Crosstab Query on tables with Many to Many relationship 7
Querying Multple Tables in Access with different fields 4
Selecting data to run a query by using a drop down list 1
XML question on elements, child and children of childs... 5
Exicute an append query in an after update event 0
One To Many To One Common Problem 2

Back
Top