Lin: Ques 1. Put a simple pause 2 (such as 'we are here' ) as the first statement to insure that you are geting into the on-exit eep.
Quest 2. On the new account, if you are seeing data in the fields, it indicates your insturction for the new account is 'edit using' when it should be 'enter using'. Good Luck ----- Original Message ---- From: Lin MacDonald <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, January 22, 2008 5:59:35 AM Subject: [RBASE-L] - same Form question again. Sorry, this one is still eluding me: Verifying Data Entry. I'm developing a form that is very similar to the SalesOrder form in RRBYW14. Once the User chooses a Supplier, the address on record appears. (Not changeable). Then, they enter the Description of the item being purchased (only 1 item per form, as opposed to the RRBYW14 example). Once they enter the field to input the description, I want to check that they haven't left the Supplier field blank, and if they have, send them back to it. I added an EEP on Entry into the Description field, but nothing seems to happen. Here's what I put in: IF vref# IS NULL THEN PAUSE 2 USING 'You MUST Select a Supplier!' CAPTION ' New Transaction' ICON stop SKIP TO ref# RETURN ENDIF SELECT company INTO vpurchfromcompany INDICATOR ivpurchfromcompany FROM contacts WHERE ref# = .vref# RECALC VARIABLES RETURN This is a suggestion I was given: The code should be on exit from the field you are verifying. You can then use IF vref# IS NULL THEN PAUSE 2 USING 'You MUST Select a Supplier!' CAPTION ' New Transaction' ICON stop SKIP 0 -- that's a zero RETURN ENDIF SELECT company INTO vpurchfromcompany INDICATOR ivpurchfromcompany FROM contacts WHERE ref# = .vref# RECALC VARIABLES RETURN Still nothing. The field that the User chooses from is a DBLookUpComboBox. It references another table. From the other table (Contacts) it displays a Supplier name which uses a PK called REF#. The column REF# does not show; just the Name. I want the User to either choose a Supplier from the Drop down list, or utilise the Speed Button next to it to open another form and enter a new Supplier. Question 2: when the SpeedButton above is clicked, it calls up a form for entering a new Supplier. However, the form always appears with the first row of data in it, instead of a blank form. Same thing happens when I am entering that form normally. thanks again, Lin ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
