I am trying to sort a combo box ascending on the after update event of cboCategory. I have tried to sort by Ascending in the query, however, it strangely doesn't seem to reflect the order of ascending on the cboCode combo box after the cascade of data from cboCategory on the form. Can this be done in line 31 with a of bit of VB?
[CODE] Dim sSource As String
20 sSource = "SELECT [tblElementDetails].[ElementDetailID], [tblElementDetails].[EquipmentTypeID], [tblElementDetails].
Code:
, [tblElementDetails].[Desc], [tblElementDetails].[CostPrice], [tblElementDetails].[SalePrice], [tblElementDetails].[LastUpdated] " & _
"FROM tblElementDetails " & "WHERE [EquipmentTypeID] = " & Me.cboCategory
30 Me.cboCode.RowSource = sSource
31 Me.cboCode.Column (2)