Greetings,
My Problem: I don't know all of the syntax involved in passing a parameter (TextBox.Text) from an ADODC to a Stored Procedure. Here is what I have so far:
Can anyone fill in what I'm missing? Many thanks,
My Problem: I don't know all of the syntax involved in passing a parameter (TextBox.Text) from an ADODC to a Stored Procedure. Here is what I have so far:
Code:
Private Sub cmdSearch_Click()
With Adodc1
.CommandType = adCmdStoredProc
.RecordSource = "sp_myData;1"
.Refresh
End With
End Sub
Can anyone fill in what I'm missing? Many thanks,