ComboBox Row Source Value

[mpbertha]

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.

[dcrake]

For a start I would not use the word Object to describe the name of a recordsource. If this is a table then rename the table. You need to look at naming conventions and reserved words.

David