TailGun
I had a situation like this before and solved closing the recordset and reopening with the filter and the ordering.
VB Code:
adodc1.Recordset.Close adodc1.Recordset.Open "Select * From Table WHERE AdjusterLastName = '" & DataCombo1.Text & "' ORDER BY [AdjusterLastName]"




Reply With Quote