instead of doing it in the SQL statement, do it when you fill the combo

VB Code:
  1. while not rs.eof

  2.    cbo.AddItem rs("field") & ""

  3.    rs.movenext

  4. wend