I am pulling my hair out over this one and am now waving the white flag!
I have a combo box which is populated from a table. The combo box is for [Priority]. I would like to populate the [TargetDate] automatically based on the date the job was identified and the priority.
ie; a High Priority job has a target date of 14 days from date identified; a medium has 28 days etc etc
To further complicate the issue, the fields I am referring to are on a subform.
I would like to have the user see the target date change when the priority is changed.
Can anyone help? I must also point out that I am not a great one for fancy coding either... I get easily confused! NKA
The answer's always easy - if you know it! ;-)
I have a combo box which is populated from a table. The combo box is for [Priority]. I would like to populate the [TargetDate] automatically based on the date the job was identified and the priority.
ie; a High Priority job has a target date of 14 days from date identified; a medium has 28 days etc etc
To further complicate the issue, the fields I am referring to are on a subform.
I would like to have the user see the target date change when the priority is changed.
Can anyone help? I must also point out that I am not a great one for fancy coding either... I get easily confused! NKA
The answer's always easy - if you know it! ;-)