mkovacs13
Member
I have been scouring the internet for days trying to get a cascade of dependent comboboxes working, however no luck, so i was hoping that someone here might be able to provide so assistance.
I have an access db with two tables (Type) and (Model)
In Type the fields are: TypeID(Auto # pkey) and type (text)
In the Model Table are the fields: TypeID(Number) , ModelID( Auto # pkey) and Model (Text)
trying to be a simple as possible to make my incompetence clear
i add these two tables as a datasource in VB Express 2010, which makes a dataset labeled "Information", i also ensure that the Type is the Parent table and the Model the child with the "TypeID" as the relation between the tables
I have two comboboxes (cbo1, and cb2)
I can have the databound to the comboboxes but what i really need is the following:
in Cbo1 there are only two options ("Floor" - a TypeID of 1 & "Overhead" a TypeID of 2)
when i select "Floor" - a TypeID of 1, i want Cbo2 to only show Models of the "Floor" type.
am i crazy in thinking this is impossible?!?!
any help would be greatly appreciate
I have an access db with two tables (Type) and (Model)
In Type the fields are: TypeID(Auto # pkey) and type (text)
In the Model Table are the fields: TypeID(Number) , ModelID( Auto # pkey) and Model (Text)
trying to be a simple as possible to make my incompetence clear
i add these two tables as a datasource in VB Express 2010, which makes a dataset labeled "Information", i also ensure that the Type is the Parent table and the Model the child with the "TypeID" as the relation between the tables
I have two comboboxes (cbo1, and cb2)
I can have the databound to the comboboxes but what i really need is the following:
in Cbo1 there are only two options ("Floor" - a TypeID of 1 & "Overhead" a TypeID of 2)
when i select "Floor" - a TypeID of 1, i want Cbo2 to only show Models of the "Floor" type.
am i crazy in thinking this is impossible?!?!
any help would be greatly appreciate