Using a sql stored proc as an access combobox rowsource
Posted on 2014-03-12
So, I am trying, as the title suggests, to use a SQL stored proc as the rowsource for a combobox, and I am having a great deal of difficulty. Here is the latest code I have tried:
Private Sub Form_Load()
Dim conn As ADODB.Connection
Set conn = SQLConnection()
Me!cboProject.RowSource = "EXEC Ren.up_RenManJobSelect"
I have also attempted to use a recordset, but that didn't work either. Is there something I am missing?