SQL sorting

I just want to know if this is the best way to do this. It's for sorting a list with 2 parameters (strSort and strType). Or I use both, only strSort or only strType or Nothing. Any other suggestions pls let me know.

If strSort = "" AND strType = "" Then
 rsList.Source = "SELECT * FROM tblList"
 ElseIf strSort <> "" AND strType = "" Then
 rsList.Source = "SELECT * FROM tblList ORDER BY " & strSort & " ASC"
 ElseIf strSort = "" AND strType <> "" Then
 rsList.Source = "SELECT * FROM tblList WHERE Type=" & strType2 & ""
 ElseIf strSort <> "" AND strType <> "" Then
 rsList.Source = "SELECT * FROM tblList WHERE Type=" & strType2 & " ORDER BY " & strSort & " ASC"
End If

Personally I would do it as follows:

strSQL = "Select * From tblList "
If strType <> "" Then
  strSQL = strSQL & "Where Type=" & strType2 & " "
End If
If strSort <> "" Then
  strSQL = strSQL & "Order By " & strSort & " Asc "
End If
rsList.Source = strSQL

Hope this helps,
Blair

Don't know, they're both using If...ElseIf blocks, so they should be about the same. The main reason I do it that way is because it is easier, and makes neater code, than writing all the combinations yourself. It is not so noticeable with just two options, but if you have four options, then there are (I think) 12 different combinations.

Blair