I have a simple Table "Videos table" i want to display the names of videos in just 1 category.

[Aztecfan63]

My Video Table contains over 700 videos in 19 categories.


I have a form (Select Category) that will show a combo box that will list the categories. When the user clicks on their choice of category, how do i use that choice to display the names of the chosen videos?

[davegri]

We need an image of your form to see where to start. Better yet, upload your database. If you don't want to show all your data, just include a few videos with fake names.
Don't be surprised when you get replies that your DB structure needs more tables. However you might be able to satisfy your needs if the table you mention is the only one.

[June7]

Apply filter criteria to form's Filter property.

Best to filter by numeric ID's than text descriptors. So, if value of combobox is category ID, code would use that. Do you want to use macros or VBA?

VBA code in combobox AfterUpdate event could be like:

Me.Filter = "CategoryID=" & Me.comboboxname
Me.FilterOn = True

Review this article http://allenbrowne.com/ser-62.html

[Aztecfan63]

This is my Select form. The dropdown is connected to categories table. which lists 19 categories. when I click on one of the categories I want to display the list of DVD names from the selected query. I have 19 queries.

[davegri]

You can't paste images here. You have to attach them.

[ArviLaanemets]

Create a continuous form based on your DVD's table (I assume there is a category field present);
Add this form as subform into your Select form;
Set your categories combo in your Select form as LinkMasterFields, and the category field of DVD's table as LinkChildFields of subform.

Now whenever you select a category in combo, the subform displays any info you designed the subform to display for all DVD's of selected category.

[davegri]

Using Copilot to get list of movies and categories for test data made this easier.
Industry practice uses the word 'Genre' rather than 'Category'.
Used wizards to create forms and combobox lookups, so no VBA code employed.
The DB uses NO queries at all.

aztec-davegri-v01.zip