I have 3 forms which displays the dates of the tests that we are doing. The dates of each following test must be on the same/later date as before. All dates are from the same table.
For example, I have 5 Tests.
Date of Test 1
Date of Test 2 must same or after Test 1
Date of Test 3 must same or after Test 2
Date of Test 4 must same or after Test 3
Date of Test 5 must same or after Test 4
The subform in FormA displays the dates for Test 1 - Test 5.
The subform in FormB displays only the dates for Test 4 and Test 5.
The subform in FormC displays only the date for Test 3.
The solution from Microsoft support said that I should make a validation rule to the fields.
So on FormA, I did a Validation Rule for each dates like this: [Test2]>=[Test1].
But the problem is, I also have Form B and Form C where people can input the dates and this validation rule does not applies on these Forms B and C.
Is there any way I can put a warning sign on Form B and C, if they entered the dates wrong?
For example, I have 5 Tests.
Date of Test 1
Date of Test 2 must same or after Test 1
Date of Test 3 must same or after Test 2
Date of Test 4 must same or after Test 3
Date of Test 5 must same or after Test 4
The subform in FormA displays the dates for Test 1 - Test 5.
The subform in FormB displays only the dates for Test 4 and Test 5.
The subform in FormC displays only the date for Test 3.
The solution from Microsoft support said that I should make a validation rule to the fields.
So on FormA, I did a Validation Rule for each dates like this: [Test2]>=[Test1].
But the problem is, I also have Form B and Form C where people can input the dates and this validation rule does not applies on these Forms B and C.
Is there any way I can put a warning sign on Form B and C, if they entered the dates wrong?