I have a client form that depends on a client table. One of the fields in both objects is a pull down which lists the different programs to which the client can be assigned to (one of which is "Discharged", and another field is a possible discharge date. I want the form to inforce the rule by which if the program fields contains "Discharged" then the DischargeDate field MUST contain a valid discharge date, otherwise the DischargeDate field should be blank. I have tried applying the validation rule: ([Program] = "Discharged" And [DischargeDate] Is Not Null) Or ([Program] <> "Discharged" And IsNull([DischargeDate])) This rule seem to work when applied to the Client table validation rule, however when I'm using the form I don't get my expected validation text which is "Invalid Discharge Date". I want the form to display the validation text and place the user back into the same record so he/she can correct the error.