Jim, Do you have any lookup Form variables defined? Those always win.
Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 21 Jun 2010 07:34:55 -0500 Subject: [RBASE-L] - Re: tab form JAN, I CHECKED THAT. I MAY HAVE TO JUST TAKE A BREAK AND START FROM SCRATCH. JIM From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Monday, June 21, 2010 7:16 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: tab form Jim, Check the componentid for Comp_BOLPkg does not have any trailing spaces.. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 21 Jun 2010 05:37:18 -0500 Subject: [RBASE-L] - tab form I am creating a tab form based on two tables which will allow the user to update specific fields. One field is the total package quantity field (Integer). In an On exit EEP (from a field) in the detail section I have this code. SAVEROW SELECT (SUM(PackageQty)), (SUM(PackageTotWgt)) INTO + vPackTot INDIC ivPackTot, + vBOLWeight INDIC ivBOLWeight, + FROM BOLRows WHERE Control# = .vControl AND BOLDate = .vBOLDate PROPERTY Comp_BOLWgt TEXTVALUE .vBOLWeight PROPERTY Comp_BOLPkg TEXTVALUE .vPackTot RECALC VARIABLES RETURN The BOLWeight column (REAL) in the Header updates properly when detail rows are changed . For some reason the BOLPkg column (INTEGER) will not update when the detail rows are changed. When I do a trace on the variables, both of them change whenever the information in the detail sections change. Anyone see something I may be doing wrong in this code? Jim
