I have a subform that records date parameters, that is DateFrom and DateTo. The subform is set to continuous forms. When adding a new record, they use the blank record at the bottom of the list. If the user enters a date in the DateFrom field, I need to make sure the new date is not in one of the ranges in the previous fields. Here is an example:
DateFrom.......... DateTo
1/1/16 .................6/30/16
7/1/16 ................12/31/16
1/1/17 ..................6/30/17
If I enter a new record and put 2/1/17, in the DateFrom field, I need the program to tell me that date is already covered (See line 3). Can I do that?
Thank you.
DateFrom.......... DateTo
1/1/16 .................6/30/16
7/1/16 ................12/31/16
1/1/17 ..................6/30/17
If I enter a new record and put 2/1/17, in the DateFrom field, I need the program to tell me that date is already covered (See line 3). Can I do that?
Thank you.
