Command Button DateAdd

[Suoipoc]

I have a form with a command button and I need it to insert the current date + 3 months. So if today is 1/1/11 I need it to insert the date 3/1/11. This date field does not always need the advanced date, sometimes it will be manually entered as a different date, so having a query auto add to the date will not work. I need it to be in my form.



This is what I currently have as an event procedure: [Forms]![ContactDetails]![NxtCntact] = DateAdd(month, 3, Date)
Can Someone please help me.

[orange]

What exactly do you want? You said you had a button, and associated with it is a Click event. However, you want it somehow to know when the Click is real and another somehow to know the Click is just a signal to do some manual activity.

I think you need to decide what criteria is needed to use Date + 3 Months, AND
what exactly are the conditions to do a manual insertion of a Date.

We can't guess what triggers these. You will have to determine the criteria, tell us, and hopefully someone can help.

[Suoipoc]

I’m sorry that I was not specific enough. There is a command button, and there is a date field, the user can choose to click on the command button in order to insert the date +3months or they can click on the date field and manually enter. Either way, it is a manual operation. The user clicks either the command button or the date field. I just need to know how upon “click” to make it insert date + 3months. I have several command buttons that insert Date(), but beyond that I’m at a loss.

[orange]

see http://www.techonthenet.com/access/f...te/dateadd.php

for use and syntax of DateAdd function

[khalid]

... There is a command button, and there is a date field, ...

The rough idea and command goes here:

Private sub Command1_Click()
YourDateFieldOnTheForm.Value= YourDateFieldOnTheForm + 30
End sub