Does anyone know how you can consturct a form that has multiple combo boxes that are dependent on one another. The form is being used to select criteria used to query a master data set and filter the results of the query by the selected criteria. Any help is appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Combo Boxes
- Thread starter DSerr77
- Start date
SkipVought
Programmer
Hi,
Basics in How can I rename a table as it changes size faq68-1331
Learn how to use the OFFSET function. It can define DYNAMIC named ranges. One selection defines the range for its subset. You must also design a proper table from which the selections can be defined.
You'll also need to use the Advanced Filter to generate one or more UNIQUE lists from your table. Each list that you generate can be named with the OFFSET fucntion in Insert/Name/Define to make the range DYNAMIC.
Skip,
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
Basics in How can I rename a table as it changes size faq68-1331
Learn how to use the OFFSET function. It can define DYNAMIC named ranges. One selection defines the range for its subset. You must also design a proper table from which the selections can be defined.
You'll also need to use the Advanced Filter to generate one or more UNIQUE lists from your table. Each list that you generate can be named with the OFFSET fucntion in Insert/Name/Define to make the range DYNAMIC.
Skip,
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...Neopolitan Blownapart!
- Status