M
MGC
I am workng in Access 2003 and need some help with cascading combo boxes.
Here's the scenario:
Combo 12 - Entity from tblEntity, Entity Field
Combo14 - AcctgPeriod-value list of 1 through 12
Combo 16 - Department from tblGlCodeInfo, Department Field
I also have a query which has all of these same items...it's name is
qryBudgetData.
Combo12 should filter into Combo14 and Combo16 selections should be based
upon the selections made in Combo12 and 14.
I also have three other boxes: Budgeted Amount, Sum of Invoices and Budget
Variance which all come from qryBudgetData. These I want to auto-populate
depending upon the Combo Box selections.
I also have a subform which will house the AP data for the specific
entity/period/dept selected previously and have linked the master and child
fields. My concern at present is getting the Combo Boxes to cascade and the
other three boxes to auto populate though.
I have already tried using TechOnTheNet, FontStuff, etc. but continue to
have problems with this. I have not set any of the events or anything in
properties as I'm not exactly sure how. Please help if you can.
Here's the scenario:
Combo 12 - Entity from tblEntity, Entity Field
Combo14 - AcctgPeriod-value list of 1 through 12
Combo 16 - Department from tblGlCodeInfo, Department Field
I also have a query which has all of these same items...it's name is
qryBudgetData.
Combo12 should filter into Combo14 and Combo16 selections should be based
upon the selections made in Combo12 and 14.
I also have three other boxes: Budgeted Amount, Sum of Invoices and Budget
Variance which all come from qryBudgetData. These I want to auto-populate
depending upon the Combo Box selections.
I also have a subform which will house the AP data for the specific
entity/period/dept selected previously and have linked the master and child
fields. My concern at present is getting the Combo Boxes to cascade and the
other three boxes to auto populate though.
I have already tried using TechOnTheNet, FontStuff, etc. but continue to
have problems with this. I have not set any of the events or anything in
properties as I'm not exactly sure how. Please help if you can.