Recordset is not Updatable

M

Mark Mizner

I am linking two tables of data via ODBC connection from
DDF files. I also created one internal Table to Access.
I run one query (qryShipSchedule) to filter only the open
sales orders from one of the linked tables.

Then in a second query I have qryShipSchedule, plus the
other linked table and the table I created in Access. The
production manager wants to put comments in the table I
created in Access, matched to the data for the sales
orders and line items in a form/subform arrangement. Then
make an export file to email.

The problem is, I get the Recordset is Not Updateable
error. I have checked for locked records and none of the
queries seem to have them on. Example of the code for the
second query (& form/subform, & report) is as follows:

SELECT ORHDR.Ordno, ORHDR.Custname, ORHDR.Orddate AS
[Order Date], tblEdsComments.e_RequestedDate,
tblEdsComments.e_ScheduledDate, qryORLINDesc.Product, IIf
([Recstat]="NN","New Order",IIf([Recstat]="NP","New - Not
Posted",IIf([Recstat]="BN","Back Order - Not Posted",IIf
([Recstat]="BP","Back Order - Posted",[Recstat])))) AS [BM
Status], ORHDR.Shipvia, tblEdsComments.Comments,
tblEdsComments.[CR Approved], tblEdsComments.CofA,
tblEdsComments.[Production Status]
FROM (ORHDR INNER JOIN qryORLINDesc ON ORHDR.Ordno =
qryORLINDesc.Ordno) LEFT JOIN tblEdsComments ON
ORHDR.Ordno = tblEdsComments.Ordno
WHERE (((ORHDR.Recstat)<>"S" And (ORHDR.Recstat)<>"C"))
ORDER BY ORHDR.Ordno;

Any assistance would be most appreciated, thank you.

Mark M.
 
Top