Using SQL Table as RowSource For Access ListBox

[RunTime91]

Hello...

I'm ever so close to completing this project (Haha, no such thing) but at least for the moment my last hurdle is to populate my ListBoxes using SQL tables

The following works great using a local/linked table

With Me
  .ListEmailAgnts.Visible = True
    .CmdSbmtNewNac.Visible = True
  .ListEmailAgnts.RowSource = "SELECT TblTmpTktEmail.EmpName, TblTmpTktEmail.EmpID " & _
                                             "FROM TblTmpTktEmail"
End With

I'm trying to get the following code (and iterations thereof) to populate directly from the SQL Table

Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.ConnectionString = strConnection
conn.Open

With Me
 .ListEmailAgnts.Visible = True
  .CmdSbmtNewNac.Visible = True

StrSQL = "SELECT tri.TktEmailTmp.EmpName, tri.TktEmailTmp.EmpID " & _
              "FROM tri.TktEmailTmp"

.ListEmailAgnts.RowSource = StrSQL  
End With

No errors - but ListBox is left empty

Thanks for any help?

[ranman256]

link in the sql table as a table
build a query
set the listbox to this query

[RunTime91]

Hey Ran Thanks for chiming in..

I was kinda hoping to keep all the tables in SQL - (not even sure if that can be done)

Either way, your solution works perfectly!

Thanks again ranman