Hi, I'm creating a database of contracts and have run into some issues when it comes to validating the forms.
Each contract in the database is taken on by multiple affiliates which each take a certain percentage. So in the form for creating a new contract entry, I have a subform that allows you to pick from a group of affiliate and then type in what % of the contract they have taken on. I want to be able to validate it so that the % amount of all the affiliates combined does not exceed 100%. So if the first affiliate took on 90%, when putting in the next affiliate's information it couldn't exceed 10%.
Also, contracts generally last a year, so when the incept date is put in, I want the expiration to automatically go to 1 year after that date. I currently have in the AfterUpdate of the incept date
"Me.Expiration_Date = DateAdd("yyyyy", 1, Me.Incept_Date)"
However its not working---I have gotten this to work previously, but it seems fickle and only works some of the time so I am not quite sure what is the issue.
Hopefully someone out there has some insight!
Thanks in advance!