Question

Locked

Access2007. populate a combobox based on the selection of another one

By karamcarole ·
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 :


SELECT PROBLEMS_TYPES.PROBLEM_TYPE
FROM PROBLEMS_TYPES
WHERE (((PROBLEMS_TYPES.KPI)=[Forms]![Form_KPI]![Combo_KPI]))
ORDER BY PROBLEMS_TYPES.KPI;



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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums