Populating Controls

[nullig]

I have a database of TV Shows I have on CD/Tape, which contains fields for "Show Title", "Season #", "Episode #", "Episode Name" and "Original Air Date".

I have a form with a Combo Box for selecting the "Show Title" and a Tab Control with Tabs for each "Season", on which I would like a datasheet showing the episode info.

I need someone to point me in the right direction for coding this.

Thanks

 

[legos]

You can make a listbox for each season tab you have for starters. In this example your table with all of your CD/Tape info is called TVShows, also make sure there aren't spaces or odd characters in your fields, it just complicates things
Then in the row source enter something like this:
SELECT Tvshows.showtitle, Tvshows.season, Tvshows.episodenum, Tvshows.episode
FROM TVshows
WHERE ((Tvshows.season) = "x") And ((Tvshows.showtitle) = "&comboboxname&")
ORDER BY TVshows.episodenum;


Durible Outer Casing to Prevent Fall-Apart