TailGun

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