Posted on 2012-03-15
I have this form.
It is a Tasks Form.
There is a date field with control source [DueDate]
I continually need to choose Monday as the DueDate and I want to make this a little quicker.
How can I modify this:
Me.Due_Date = Date + 1
to always default to Monday's date (3/19/2012) if I press the button?
Lets say if today is 3/15/2012 and if I click the button then the [DueDate] will change to Moday, which is 3/19/2012. But, of course I could be on any day such as Tuesday, Wed, etc... so I cant hardcode it like I did in the above (Me.Due_Date = Date + 1)
Any ideas? thank you