Dear all,
I need your hep with this issue. I am usng Access 2007. I need to populate a combo box based on the selection of another combo box.
The master combo box or the controler ombo box is named KPI. I have put in the After Update event :
Private Sub Combo_KPI_AfterUpdate()
Me.Combo_PROBLEM_TYPE.Requery
End Sub
The second combo box controlled has a query :
[CODE]
SELECT PROBLEMS_TYPES.PROBLEM_TYPE
FROM PROBLEMS_TYPES
WHERE (((PROBLEMS_TYPES.KPI)=[Forms]![Form_KPI]![Combo_KPI]))
ORDER BY PROBLEMS_TYPES.KPI;
[/CODE]
At runtime, I am always prompted for enter parameter value for the master combo box in order to poulate the second combo box. Can someone help me please
