***RESOLVED****need some coding help

[Tailgun]

How do I add ORDER BY [AdjusterLastName] in the following ??

Adodc1.Recordset.Filter = "AdjusterLastName = '" & DataCombo1.Text & "'"

Thanks for any and all help

[ZeroCool]

Isn't that a SQL Command?

[ZeroCool]

I Think This is what you want

adodc1.Recordset.Open "Select * From Table ORDER BY [AdjusterLastName]

[Tailgun]

yes it is a SQL command but if I use

adodc1.Recordset.Open "Select * From Table ORDER BY [AdjusterLastName]

It works fine till I filter the recordset then it will not ORDER BY

I have to filter the recordset since the user selects a Client and based on that client only those Adjusters associated with that client appear in the DataCombo Adjusters list hence the original problem where the recordset is filtered by a Client DataCombo.

I dunno why it doesn't maintain the original ORDER BY when it is later filtered

[LucianoBraatz]

TailGun

I had a situation like this before and solved closing the recordset and reopening with the filter and the ordering.

adodc1.Recordset.Close
adodc1.Recordset.Open "Select * From Table WHERE AdjusterLastName = '" & DataCombo1.Text & "' ORDER BY [AdjusterLastName]"

[Tailgun]

thanks LucianoBraatz
that did the trick