I guess one very simple question to ask you -- you must have a form variable defined for: vref# = ref# ???? Also, double-check that you have Ref# selected as the column for your edit field (I'm forgotten that many times!)
Also, if you're using version 7.x, you should stop using "skip to" and use the more accurate: PROPERTY <componentid for ref#> SET_FOCUS 'TRUE' You also mention "speed button". You have to be careful with speed buttons because they are "focus-less", in that if you click on a speed button you actually have never left the field you were on before. RBase thinks you're still on that previous field, so if you have exit eeps on that field they will not evaluate (unless RBase has changed that behavior since I last used speed buttons). Karen > 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, >
