Hello, I am trying to pass a variable called rep into a sql string and i keep getting an error that my parameter does not have a value.
Anyone ever dealt with this?
rep = ComboBox1.Value
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
' connect to the Access database
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:\Documents and Settings\speared\My Documents\db1.mdb"
' open a recordset
Set rs = New ADODB.Recordset
rs.Open "(SELECT name FROM [David] where salesrep=rep)", cn, adOpenKeyset, adLockOptimistic, adCmdTable
Anyone ever dealt with this?
rep = ComboBox1.Value
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
' connect to the Access database
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:\Documents and Settings\speared\My Documents\db1.mdb"
' open a recordset
Set rs = New ADODB.Recordset
rs.Open "(SELECT name FROM [David] where salesrep=rep)", cn, adOpenKeyset, adLockOptimistic, adCmdTable