I can't remember how to do this...The lower sub-form where the field MedNeccessityDate is highlighted in orange is based on a query which links a two queries together (qrydemoclients) and (DAclients). The field in the upper sub-form MedNeccessityDate is where the Med Neccessity is actually entered by the user, but I have that same field in the lower sub-form query so when it is entered in upper sub-form it automatically appears in lower sub-form in that field highlighted in orange. What I am trying to accomplish is this....In the lower subform, If the user selects DA is Needed - Yes, then I want the Date DA Needed field to automatically calculate to 14 days from the MedNecessityDate. If the Follow-up DA is Needed, then I want the Date Follow-up is Needed field to automatically calculate to 14 days from the MedNecessityDate. I think I have the whole MedNecessityDate set up wrong because I have tried putting that calculation on the After-Update of the orange field, but I'm thinking since I do not actually enter the data into that field, that is going to work. Can anyone help me with this code? Thanks.