I have the following code that returns values from a Stored procedure. However, don't appear to be able to bind the RecordSet to a form. The Stored procedure is running and I can see Field values returned.
Dim rst As New ADODB.Recordset
Dim con As New ADODB.Connection
IdValueToProcess = 12300 ' test data
con.ConnectionString = "????"
rst.Open "EXEC dbo.Martin " & IdValueToProcess, con
Set Forms!Form1.Recordset = rat
On the last line, I get an error message saying
The object you entered is not a valid Recordset property