Nolo
09-14-2008, 10:38 AM
I have very basic code that I think is successfully triggering a stored procedure.
The code is fired in the OnClick event for a button on my 'empty' form.
I want to populate the form with data called from the stored procedure after the button is clicked.
What I don't know how to do is ACCESS the data set once the SP returns it...
Here's the code:
MsgBox "before"
Dim STRSQL As String
STRSQL = "EXEC {sptest}"
DoCmd.RunSQL STRSQL
MsgBox "after
Both message boxes are poping up so I'm assuming the stored procedure fires and is storing the data - how do I display it on the form????
The code is fired in the OnClick event for a button on my 'empty' form.
I want to populate the form with data called from the stored procedure after the button is clicked.
What I don't know how to do is ACCESS the data set once the SP returns it...
Here's the code:
MsgBox "before"
Dim STRSQL As String
STRSQL = "EXEC {sptest}"
DoCmd.RunSQL STRSQL
MsgBox "after
Both message boxes are poping up so I'm assuming the stored procedure fires and is storing the data - how do I display it on the form????