If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update the Date Field
I am trying to create a form that has 2 date fields. Court Date, and Due
Date. The Court Date is just a basic Date field, but when I exit that field or enter into the Due Date field I want the Due Date field to be the Court Date + 45 Days and update automatically. How do I do this. I found an expression to build using DateAdd ( "d", 45, "date"). I don't know what to put in for the Date. I tried pointing it to the Court Date field but it does nothing. Any help would be much appreciated. |
#2
|
|||
|
|||
If you name the two text boxes containing the fields txtCourtDate and
txtDueDate and format both as dates, you might use this code that will execute after you enter a value for court date. Private Sub txtCourtDate_AfterUpdate() Me.txtDueDate = Me.txtCourtDate + 45 End Sub "Chris Peikert" wrote: I am trying to create a form that has 2 date fields. Court Date, and Due Date. The Court Date is just a basic Date field, but when I exit that field or enter into the Due Date field I want the Due Date field to be the Court Date + 45 Days and update automatically. How do I do this. I found an expression to build using DateAdd ( "d", 45, "date"). I don't know what to put in for the Date. I tried pointing it to the Court Date field but it does nothing. Any help would be much appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date field - No update | Tony | Mailmerge | 2 | July 22nd, 2004 05:45 PM |
ASK Field Behavior | Greg | Mailmerge | 9 | July 2nd, 2004 02:44 PM |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 05:08 PM |
How to calculate 12 months from "Date Added" field | Sandi Gauthier | Worksheet Functions | 2 | November 19th, 2003 06:01 PM |