Interestingly, this is happening only within the form. On the stand alone view there are no problems. Besides, it is not allowing edits also, giving the same message.

My code:

SELECT Stockbook.ddate, Stockbook.nlotid, Items.cname,;
  Itemhead.citemhead, Stockbook.cdetails, Stockbook.ncompcode,;
  Stockbook_a.ncost, Stockbook.nqtyin, Stockbook.nqtyout,;
  IIF(Stockbook.nqtyin>Stockbook.nqtyout,Stockbook.nqtyin*Stockbook_a.ncost,Stockbook.nqtyout*Stockbook_a.ncost) AS value,;
  Stockbook.copr, Stockbook.clocation, Stockbook.ntransid;
 FROM ;
     accounts!stockbook ;
    INNER JOIN accounts!items ;
   ON  Stockbook.nitemcode = Items.nitemcode ;
    LEFT OUTER JOIN accounts!stockbook Stockbook_a ;
   ON  Stockbook.nlotid = Stockbook_a.nlotid;
   AND  Stockbook_a.lnew == ( .T. ) ;
    INNER JOIN accounts!itemhead ;
   ON  Items.nsubitcode = Itemhead.nitemcode;
 ORDER BY Stockbook.ddate, Stockbook.nitemcode

DBSetProp(ThisView,"View","SendUpdates",.T.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","accounts!stockbook")
DBSetProp(ThisView,"View","WhereType",2)

DBSetProp(ThisView+".ddate","Field","DataType","D")
DBSetProp(ThisView+".ddate","Field","UpdateName","accounts!stockbook.ddate")
DBSetProp(ThisView+".ddate","Field","KeyField",.F.)
DBSetProp(ThisView+".ddate","Field","Updatable",.T.)

DBSetProp(ThisView+".nlotid","Field","DataType","N(10)")
DBSetProp(ThisView+".nlotid","Field","UpdateName","accounts!stockbook.nlotid")
DBSetProp(ThisView+".nlotid","Field","KeyField",.F.)
DBSetProp(ThisView+".nlotid","Field","Updatable",.T.)

DBSetProp(ThisView+".cname","Field","DataType","C(40)")
DBSetProp(ThisView+".cname","Field","UpdateName","accounts!items.cname")
DBSetProp(ThisView+".cname","Field","KeyField",.F.)
DBSetProp(ThisView+".cname","Field","Updatable",.F.)

DBSetProp(ThisView+".citemhead","Field","DataType","C(20)")
DBSetProp(ThisView+".citemhead","Field","UpdateName","accounts!itemhead.citemhead")
DBSetProp(ThisView+".citemhead","Field","KeyField",.F.)
DBSetProp(ThisView+".citemhead","Field","Updatable",.F.)

DBSetProp(ThisView+".cdetails","Field","DataType","C(25)")
DBSetProp(ThisView+".cdetails","Field","UpdateName","accounts!stockbook.cdetails")
DBSetProp(ThisView+".cdetails","Field","KeyField",.F.)
DBSetProp(ThisView+".cdetails","Field","Updatable",.T.)

DBSetProp(ThisView+".ncompcode","Field","DataType","N(5)")
DBSetProp(ThisView+".ncompcode","Field","UpdateName","accounts!stockbook.ncompcode")
DBSetProp(ThisView+".ncompcode","Field","KeyField",.F.)
DBSetProp(ThisView+".ncompcode","Field","Updatable",.T.)

DBSetProp(ThisView+".ncost","Field","DataType","N(10,2)")
DBSetProp(ThisView+".ncost","Field","UpdateName","accounts!stockbook.ncost")
DBSetProp(ThisView+".ncost","Field","KeyField",.F.)
DBSetProp(ThisView+".ncost","Field","Updatable",.F.)

DBSetProp(ThisView+".nqtyin","Field","DataType","N(10,2)")
DBSetProp(ThisView+".nqtyin","Field","UpdateName","accounts!stockbook.nqtyin")
DBSetProp(ThisView+".nqtyin","Field","KeyField",.F.)
DBSetProp(ThisView+".nqtyin","Field","Updatable",.T.)

DBSetProp(ThisView+".nqtyout","Field","DataType","N(10,2)")
DBSetProp(ThisView+".nqtyout","Field","UpdateName","accounts!stockbook.nqtyout")
DBSetProp(ThisView+".nqtyout","Field","KeyField",.F.)
DBSetProp(ThisView+".nqtyout","Field","Updatable",.T.)

DBSetProp(ThisView+".value","Field","DataType","N(20,4)")
DBSetProp(ThisView+".value","Field","KeyField",.F.)
DBSetProp(ThisView+".value","Field","Updatable",.F.)

DBSetProp(ThisView+".copr","Field","DataType","C(3)")
DBSetProp(ThisView+".copr","Field","UpdateName","accounts!stockbook.copr")
DBSetProp(ThisView+".copr","Field","KeyField",.F.)
DBSetProp(ThisView+".copr","Field","Updatable",.T.)

DBSetProp(ThisView+".clocation","Field","DataType","C(4)")
DBSetProp(ThisView+".clocation","Field","UpdateName","accounts!stockbook.clocation")
DBSetProp(ThisView+".clocation","Field","KeyField",.F.)
DBSetProp(ThisView+".clocation","Field","Updatable",.T.)

DBSetProp(ThisView+".ntransid","Field","DataType","I")
DBSetProp(ThisView+".ntransid","Field","UpdateName","accounts!stockbook.ntransid")
DBSetProp(ThisView+".ntransid","Field","KeyField",.T.)
DBSetProp(ThisView+".ntransid","Field","Updatable",.T.)

Steve