How to use unbounded form to retrieve recordset from Stored Proced

[Guest]

Hi all, I am new in using Access to get recordset back from SQL Server. Here
is my problem:
I am using ADO to access MS SQL Server. I also have a unbound form.
Question is what do I need to do on Stored Procedure to return the recordset
or make the recordset avaiable to Access form and how do I code the
recordsource of the unbound form? Any example is greatly appreciated.
Thanks in advance.

 

[Guest]

Don't let the SQL Server issue throw you. It isn't really that much
different. I have not personally been in a situation where we used stored
procedures, so I don't know if that will be of any advantage or not.
First, as to your question regarding record source for an unbould form.
There is no such thing. That is what an unbound form is - it has no record
source. So, for using unbound forms, I would suggest you use an SQL query to
retrieve the record you want to display/edit. Then you will need to load the
table fields into the form controls using VBA. Once you have made the
modifications in the form, you will have to update the record using VBA.