Can anyone help me. I am trying to base one combo box (SubCategoryList) on
the value in another combo box (CategoryList) I have downloaded the same
data
base from MicroSoft and followed the instructions provided, but was unable
to
get the "lookup" to work. I have the combo fields on a Form and have
written
queries for the look up in the Category Field and in the Subcategory
field.
Then I built the code for event, but for some reason it is not working. My
tables are
1. Category, with fields - ID (auto number), Category Name and CatNotes
2. Subcategories, with fields - ID (auto number), CatID (same as ID from
Category Table), Sub-Category, and Keywords
My form - called frmtestCombined has two combo boxes named
cboCategorySelect
and this box works correctly. Second box is named cboSubCatSelect and
provides me with zero values to select from. Here is the syntax that I
have
used for the "event" for the cboCategorySelect box:
Option Compare Database
Private Sub CatName1_AfterUpdate()
Me!cboSubCatSelect.Requery
End Sub
Private Sub cboCategorySelect_BeforeUpdate(Cancel As Integer)
End Sub
Private Sub cboSubCatSelect_AfterUpdate()
End Sub
Private Sub Form_Current()
Me!cboSubCatSelect.Requery
End Sub
Any help would be greatly appreciated - I am about ready to throw the
computer out the window!
--
Chucklez
|
