MS Access 2000: Forms (Lookup Data)

I created a database to manage various websites and their various Mailing List.

First I created a Mailing List form which captures the name of the website (that the Mailing List belongs to) and the name of the Mailing List.

On the Subscribers form, I'm trying to make it so when the end-user selects the "website" (from a drop down list) that "only" the Lists from the respective website appears in the next field... for the end-user to choose from... Which would be the Mailing List that the subcriber is joining.


For ex. lets say there are 3 websites in the system... MSN, Yahoo, & Tech Support Guy. Each website has 3 different Mailing List.

If the end-user selects "Yahoo" in the first field, I only want the Mailing Lists for Yahoo to appear in the next field... for the end-user to choose from. Once the end-user has the limited Yahoo list, he then would select the Mailing List that the Subscriber is joining.


PLEASE HELP

 

Hi, Keith. Not much time to look FOR you, but what they're called is either cascading dropdowns or conditional dropdowns.

 

Thanks Dreamboat... I'll see what i can find.