Thanks Larry. Moving the DROP out of the form eep did the trick. -----Original Message----- From: Lawrence Lustig [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 6:29 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: EDIT using form problem
> However, when I run it using EDIT USING formname, I get an access > violation every time I close the form. I've narrowed it down to the > ON CLOSE EEP (see below). > >>>>>IF vnum1 = .vnum2 THEN > DROP tcolcheck > CLEAR ALL VAR > RETURN > ELSE The most obvious thing to look at is some kind of involvement of the table tColCheck on your form. Is it used in a lookup? As part of a list box definition? In a WHERE clause somewhere? Is the access violation coming from RBEngine.DLL or RBG7.EXE? If the former, my bet is on that DROP statement. Try moving it outside the form. -- Larry
