Saving New record using Stored Procedure in Access

S

Shalini

Hi,

I'm using Form which stores new record using Stored Procedure written
in SQL Server. I have a New button on which I get the blank form to
enter the data and then when user enters the new record it presses
Save button to save the record in the database using Stored Procedure
to insert new record.

The problem I'm having is when its done executing the stored procedure
succesfully. It stores the record in the SQL Server but then when I
move to previous or next record it gives me error "Invalid input
parameter values. Check the status values for detail." If anyone can
help why this error is coming. any suggestions would be appreciated.

Thanks,
 

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

Dynamic Naming of Form Button 3
Using a stored procedure as record source of a form - does this wo 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Confusion over where user templates are stored in Word 1
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Capturing SQL Stored Procedure Return Codes 4
Call SQL stored procedure that inserts parameter value 0
Stored Procedure "...did not return records" Error in Access 2007 2

Top