I have a two table form in which there are three fields that MUST have information in them. I have an On Exit EEP shown below.
I am sure there is a better way to program this since I may run into a situation where more than one field may be blank. I am not sure how the program would act but chances are it would lock up or have circular responses. Any help would be appreciated. Jim -- Verify fields have information in them. IF vShipState <> vSgetState THEN PAUSE 2 USING 'Shipstate & C# State must be the same!' CAPTION ' New Order ' ICON STOP SKIP TO vShipstate RETURN ENDIF IF vPromocat IS NULL THEN PAUSE 2 USING 'You MUST Select Catagory!' CAPTION ' New Order Request' ICON STOP SKIP TO Promocat RETURN ENDIF IF vPromoID IS NULL THEN PAUSE 2 USING 'You MUST Select PromoID!' CAPTION ' New Order Request' ICON STOP SKIP TO PromoID RETURN ENDIF
