manndo
asked on
Basing field value on date in another field in Microsoft Access
Hi,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER