Cannot edit record on an Access ADP form

[Lin100]

Cannot edit record on an Access ADP form
Access 2002 and SQL 2000 Server

I had a form that uses a stored procedure to retrieve a record from a table resided in SQL Server.
It did retrieve a record, but when I placed a cursor in any of the text box field to edit it, I cannot
edit it.

///////////////////////////////////////////////////

Form Name: Frm_Test_Report_DataEntry_SWBD
Record Source: SWBD_Query_For_Form
Input Paramaters: @Department String=Forms!Selector!Dept, @SO_Number Long=Forms!Selector!so, @Item_Number String=Forms!Selector!Item

CREATE PROCEDURE SWBD_Query_For_Form
@Department nvarchar(6) = Null, @SO_Number int, @Item_Number nvarchar(10) = Null
AS SELECT Tbl_SWBD_TR.*
FROM Tbl_SWBD_TR
WHERE (Tbl_SWBD_TR.Department_Name=@Department AND
Tbl_SWBD_TR.SONumber= @SO_Number AND
Tbl_SWBD_TR.ItemNumber=@Item_Number)
GO

 

[ESquared]

You should really ask this question in the ADP forum.

This is really an Access question and not a SQL Server question. I can already tell you, though, that the most likely problem is that you don't have a primary key defined on your underlying table(s).

[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.

[sub]The best part about anything that has cheese is the cheese.[/sub][/color]