I found the answer! And I already had my coffee! Too early to think.
Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, April 15, 2009 5:25 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Checks & Balances I want to make sure two fields in a form have information (not null) before allowing the used to go to the second table in the form. I understand how to care for this for one field, but what is the proper way to check for multiple fields? Below is what I am trying but if both fields happen to be blank they still can go to the second table. IF vPromocat IS NULL THEN PAUSE 2 USING 'You MUST Select Catagory!' CAPTION ' New Order Request' ICON STOP SKIP TO Promocat RETURN ENDIF IF vShiptoState IS NULL THEN PAUSE 2 USING 'You MUST Select Catagory!' CAPTION ' New Order Request' ICON STOP SKIP TO vShiptoState RETURN ENDIF Jim
