I have a form which has three combo boxes:
1) Category (Combo0)
2) SubCategory (Combo7)
3) Object (Combo9)
Combo0 has its rowsource set to a query. The afterupdate event in Combo0 determines the rowsoure of Combo7 using this code:
Me.Combo7.RowSource = "select distinct object.subcategoryname from object where categoryname = '" & Combo0.Value & "'"
The afterupdate event of combo 7 will determine the rowsource of combo9 using this code:
Dim strSQL As String
strSQL = "select object.objectname from object where object.category = '" & Combo0.Value & "'" & _
" and object.subcategory = '" & Combo7.Value & "'"
Me.Combo9.RowSource = strSQL
So I open the form, make my selection in Combo0, this populates Combo7 successfully. However, when I make my choice in combo 7 I get a
"Enter Paramter Value" promp asking for object.category
It seems that it is not taking the category (Combo0) value.. any help is appreciated.