Adding records using form based on stored procedure?

Z

ZRexRider

Hi,

Pretty simple question but probably not a simple answer.

I tried converting my form to use simple "SELECT" stored procedure but
find I cannot add records.

Should I be able to add my table if the form's source was a stored
procedure?

Thanks
 
G

Guest

try adding a button which would open another form based on a table to be
updated.

you could also try the form / subform solution which would be more
user-friendly.
 

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

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Access ADP Form and Stored Procedure as RecordSource Options 2
Adding records using form based on stored procedure? 3
Cannot show a resultset produced by a stored procedure 2
Stored procedure as row source for a combo box 4
Running a Stored Procedure Using a Form Event 5
Stored procedure recordset not opening 9
Trouble using data from stored procedure for report! 1

Top