Hi,

My application uses a supplier form and a supplier invoice form

The supplier invoice form requires a lookup in the first Element to validate the form.

The problem occurs on the Supplier Element Entry.
With the lookup in my code (see below) the Sesame Splash Screen is displayed instead of the Supplier Invoice form.

The Userselect box appears and the code works and once selected the Supplier Invoice form then appears and work correclty for the rest of the form.

If I REM// out the Userselect the form open normally.

Has anyone else experienced this type of problem??
David


** PROGRAMMING SECTION: [ GLOBAL CODE ] [] **



** PROGRAMMING SECTION: [Supplier Invoice] [On Form Change] **
If Amount_Paid = Invoice_Total
then Status = "Paid"
else Status = "Unpaid"




** PROGRAMMING SECTION: [Supplier] [On Element Entry] **
//lookup Supplier from supplier database
If @add then XUserselect("c:\sesame\wescranes\wescranes.db","Supplier!Supplier",supplier) else Supplier = Supplier


** PROGRAMMING SECTION: [Supplier] [On Element Exit] **
If Supplier = "" then WriteLn("Supplier Name, please choose from the list of Suppliers")
If Supplier = "" then Goto Supplier

If @add then Terms = @XLookup("c:\sesame\wescranes\wescranes.db", Supplier, "Supplier!Supplier", "Terms")
goto Invoice_No


** PROGRAMMING SECTION: [Invoice_Date] [On Element Exit] **
If Invoice_Date <>""
then Due_Date = Invoice_Date + Terms
else Due_Date = ""



** PROGRAMMING SECTION: [Invoice_Amount] [On Element Exit] **
If @add
then GST = Invoice_Amount *.10
else GST = GST

If @add
then Invoice_Total= GST + Invoice_Amount

If @add
then Amount_Paid = 0

goto invoice_no

David,

Check out the @ADD description in the programming guide.  The comments on page 76 and page 94 of the Programming Guide describe the difference  They just might apply to your situation.

I have used @ADD extensively in Q&A, and upon conversion changed them all to @ISNEW. 

Since @ADD can function on a Search/update routine, it may allow the casual operator to inadvertently change a record that has been committed to the database.  The @ISNEW prohibits this.   

Jack