Thank you for the clues I need to fix the problem. All I did was move the code to a different process and now it works fine (I also fixed my code with what you said below) Im still not sure why if the data was in a table why SAVEROW in an EEP would delete the data. It seems to me that unless i re-update the data it sould just save the data as is.
Once again THANKS On 1 Oct 2003 at 9:53, [EMAIL PROTECTED] wrote: > > Victor: > > I'm sure others will point out that this not valid (should be > "is not null"): > AND DiscountID <>NULL > > You don't mention this in your posting, but since you make this statement: > "As soon as you do a saverow you lose your data updated above." > it sounds like you're doing this update in an eep, right? And is it > updating the same table that the form has? As you know, you cannot > update the same table in an eep without jumping thru a bunch of hoops > (which I have never jumped thru, although I know other programmers > have). > > > Karen > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
