Hi all,
I'm setting up a data entry screen that requires certain fields to be filled before allowing the saving of the record -- problem is, it's turning off my ability to save the record even though I've added the data later. I know I'm missing something simple, can anyone help?
Here is my code, on Form Exit: [code] if @userid <>"admin" { if DBCltNo = "" then @MsgBox ("Client Number Required!","","") if DBComRate = 0 then @MsgBox ("DB must be assigned ComRate!","","") if DBID = "" THEN @MsgBox ("DB Number Required!","","") if DBName = "" then @MsgBox ("DB Name Required!","","") if DBowes = "" then @MsgBox ("DB Amount Required!","","") if DBColl# = "" then @MsgBox ("DB Requires CollID!","","") if DBIncurred = "" then { @MsgBox ("DB Ref Date Required - setting to 120 days ago","","") DBIncurred = @date-120 } NotifyForm(1) }
ELSE NotifyForm(0) [/code]
|