Solved Cascading combo box - Sorting filtered results (1 Viewer)

[mishash]

Can't find the correct syntax to make it work. Please help.

Private Sub cboBrand_AfterUpdate()
Me.cboProductID.RowSource = "SELECT ProductID, ProductName, ProductNumber FROM tblProduct WHERE BrandID = " & Me.cboBrand ORDER BY ProductName
End Sub

 

[theDBguy]

Try:

Me.cboProductID.RowSource = "SELECT ProductID, ProductName, ProductNumber FROM tblProduct WHERE BrandID = " & Me.cboBrand & " ORDER BY ProductName"

 

[mishash]

Try:

Me.cboProductID.RowSource = "SELECT ProductID, ProductName, ProductNumber FROM tblProduct WHERE BrandID = " & Me.cboBrand & " ORDER BY ProductName"

Thank you very much!

 

[theDBguy]

Thank you very much!

You're very welcome. Good luck with your project.