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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top