Access Validation rule in MS access 2010

Joined
Nov 16, 2017
Messages
2
Reaction score
0
Hi all, I am new in this forum.

I have a table in which there is a field called "Status" which is value list field, values are "Open", "Closed", "Pending"

In the same table there is a field called "Date Closed".

I want to make a date entry mandatory to the "Date closed" field if the filed named Status is selected with "Closed"
with a pop up message to the user saying that "closed date missing"

Thanks to all in advance for your kind response.
 
Back
Top