Ok, I have used the code that was posted (copied below to save looking back) It still does not skip to that field. It is getting at least to the recalc variables as the "succsessfully inserted data" does show on the form. The thing I wonder about is. The variable invbin1 is the SAME as the field name. Mabye the trouble is that it thinks I am trying to skip to a variable rather than the field. It is strange that the same skip to command works earlier in the program. Any other ideas?
Thanks. $COMMAND updates -- test the variables -- insert the data to the matlist table -- IF invqty = 0 THEN SET V invstatus TEXT = "Retry" ELSE SET ERROR V inverror -- insert data INSERT INTO matlist jobnum, mldate, qty, partnum, discript, + price, product, margin, emp_mult + VALUES (.invjobnum, .invmldate, .invqty, .invpartnum, .invdescript, + .invprice, .invproduct, .invmargin, .invempmult) IF inverror = 1 THEN SET V invstatus TEXT = "Unsuccessful Insert" ELSE SET V invstatus TEXT = "Successfully inserted Data" ENDIF ENDIF SET V invqty REAL = NULL SET V invpartnum TEXT = NULL SET V invdescript TEXT = NULL SET V invprice CURRENCY = 0 SET V invproduct TEXT = NULL SET V invbin1 = NULL RECALC VARIABLES SKIP TO invbin1 RETURN Dan Champion P.O. Box 223 Grandville, MI. 49428-0223 www.championsolutions.net ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
