In a database I have created form to input murther records. I want to add the following condtion.



If value in first field is "Revise" than there must be an attachement in second field. If the value is "Not Required" than second field should write "Not Applicable" automatically.

I may not have cleared my question properly becuase I have just started using access. I will appreciate an easy solution.