Question

  • Creator
    Topic
  • #2213360

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

    Locked

    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 :
    [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

All Answers

Viewing 0 reply threads