Making form based on stored procedure

R

Robert

I have an Access ADP and a SQL Server database. I am a newbie with SQL
Server and ADP. I'm trying to make a form that will update a SQL Server
table using a stored procedure that I have created. How do I go about
this? Do I need code? I noticed that I can make a query by going into the
record source very similarly to an Access query and it works. But I don't
want a regular query, I want a stored procedure. Can anyone explain it?

I'm using Access 2007 and SQL Server 2008 Express.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Limit of 150 rows in a combobox? 3
multi-table select stored procedure subform ole eb error 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can I save a sql statement generated by a search form? 1
Accessing Stored Procedure via VBA 4
Can't send emails on new PC 1
Data stored in form 13

Top