Field lookups

[gtrandiak]

I'm currently developing a database to track re-airings of telvision programs in access 2k3.

I have a show field (name of the show) and an episode field (all old/new episode titles).

Currently the way the form is set is that I select the title of the show, and when I go to select the episode from the drop down combo box, I am prompted with all the episode titles in the entire episode table.

What I would like to do is upon selecting the show title, have the episode table/combo box only display those episodes related to that show.

Is this possible?

the episode table is linked to the show table right now.

Is there anything that I need to program/add etc.. Any help or assistance would be greatly appreiaciated.

TIA

-G

 

[Remou]

Try this faq702-4289

 

[gtrandiak]

Remou,

While the post was very helpful, I'm still a little unsure about how to go about this.

Does this require any VBA coding or just putting the information into the property sheet?

I can access the property sheet via the forms but i'm not exactly sure what to edit.

Any additional help would be greatly appreiciated.

TIA
-G

 

[Remou]

It is nearly all in the property sheet. Say the combo for show title is called cboShow and the combo for episodes is called cboEpisodes.

Set up cboShow property sheet:
RowSource: Select ShowID,Show From tblShows

Set up cboEpisode property sheet:
RowSource: Select EpisodeID, Episode From tblEpisodes Where ShowID=Forms!frmForm!cboShow

Are you OK with this part?

 

[gtrandiak]

Remou,

I'm ok with finding this information

this is what i currently have in my property sheet:

Table 1 (Show Information Table)
Row Source = SELECT [Show Information Table].[ShowID], [Show Information Table].[Show] FROM [Show Information Table];

Table 2 (Episode Information Table)
Row Source = Episode Information Table

That is the information I currently have listed within the property sheet.

Perhaps this will help you better. I do appreiciate all your help thus far and I believe i will grasp this.

TIA

-G

 

[Remou]

Row Source = Episode Information Table

You will need to change this to reference the show combo. Have a look at my post and come back with an attempt. That way, I'll know better how to help.

Please post the names of the comboboxes, too.