Hi there,

How would I be able to set the SQL Statements so that I have the LastName by A, B, C ... SORTED and NOT by the ID as it is now ???.

VB Code:
  1. Public Function FillList()

  2. '---

  3.     str_SQL = "SELECT ID, LastName+', '+FirstName FROM tblAddr"

  4.  
  5. End Function


VB Code:
  1. Public Function GetAddressDetails()

  2.  
  3.     str_SQL = "SELECT * FROM tblAddr Where ID =" & lngAddrID

  4.  
  5. End Function

Thanks aktell GER/NZ