S
SJW
I am trying to create a database to sort a few hundred pubications. I have
five categories, and multiple sub-categories under each category. The user
needs to enter values in each before listing the relevant publications under
that category/sub-category.
As a beginner using cascading lists, I have been using the example from
http://www.fontstuff.com/access/acctut10.htm#top and used the simplest
example ie. multiple row source tables. I created one main table ie.
tblCategoryPublications; and five other tables corresponding to each category
(as per code below).
My search includes a main cboCategory feeding the row source for
cboSubcategory. I have used the following code on AfterUpdate:
Private Sub ComboCategory_AfterUpdate()
On Error Resume Next
Select Case cboCategory.Value
Case "Market Information"
cboSubcategory.RowSource = "tblSubcategoryMktInfo"
Case "Technical Information"
cboSubcategory.RowSource = "tblSubcategoryTechInfo"
Case "Chain Integration"
cboSubcategory.RowSource = "tblSubcategoryChainInteg"
Case "Management Issues"
cboSubcategory.RowSource = "tblSubcategoryMgtIssues"
Case "Projects Information"
cboSubcategory.RowSource = "tblSubcategoryProjectsInfo"
End Select
End Sub
The problem is I cannot link the subcategory combo to the main category cbo.
I have searched through other 'cascading combos/lists' threads on this
discussion group but I cannot find how to link the cboSubcategory to the main
cboCategory. I presume it is through the rowsource, but what should the
rowsource be for cboSubcategory
I know there is probably some basic explanation, however, I cannot find the
answer on other threads.
thanks for assistance
SJW
five categories, and multiple sub-categories under each category. The user
needs to enter values in each before listing the relevant publications under
that category/sub-category.
As a beginner using cascading lists, I have been using the example from
http://www.fontstuff.com/access/acctut10.htm#top and used the simplest
example ie. multiple row source tables. I created one main table ie.
tblCategoryPublications; and five other tables corresponding to each category
(as per code below).
My search includes a main cboCategory feeding the row source for
cboSubcategory. I have used the following code on AfterUpdate:
Private Sub ComboCategory_AfterUpdate()
On Error Resume Next
Select Case cboCategory.Value
Case "Market Information"
cboSubcategory.RowSource = "tblSubcategoryMktInfo"
Case "Technical Information"
cboSubcategory.RowSource = "tblSubcategoryTechInfo"
Case "Chain Integration"
cboSubcategory.RowSource = "tblSubcategoryChainInteg"
Case "Management Issues"
cboSubcategory.RowSource = "tblSubcategoryMgtIssues"
Case "Projects Information"
cboSubcategory.RowSource = "tblSubcategoryProjectsInfo"
End Select
End Sub
The problem is I cannot link the subcategory combo to the main category cbo.
I have searched through other 'cascading combos/lists' threads on this
discussion group but I cannot find how to link the cboSubcategory to the main
cboCategory. I presume it is through the rowsource, but what should the
rowsource be for cboSubcategory
I know there is probably some basic explanation, however, I cannot find the
answer on other threads.
thanks for assistance
SJW