Hi Alex,

I have the following VBA code in the after update of the 1st combo box (cboDepart)

sCategorySource = "SELECT CatID,DepartID, CategoryName FROM VendorSetupT " & _
"WHERE DepartID=" & Me.cboDepart & "" & _"ORDER BY CategoryName"
Me.cboCategory.RowSource = sCategorySource

The problem I'm having, is when I select a field in the 1st combo box (cboDepart) the items is the 2nd combo box (cboCategory) is blank. What could be the reason for this not to appear. Both combo box are value list.

I would appreciate you sound advice with regards to this matter, as I have wasted quite some time trying to figure this out.

---

Reply from Alex Hedley:

Make sure to add a space before your ORDER BY clause.

"WHERE DepartID=" & Me.cboDepart & " ORDER BY CategoryName"

Otherwise your sql statement will look like
"WHERE DepartID=xORDER BY CategoryName"

A good way to check things like this is to use a DEBUG.PRINT statement.
So you could have
DEBUG.PRINT sCategorySource
And check in your immediate window in the VBA editor (Ctrl+G)