L1Paquette
MIS
I have two date fields in access97. Once I input a date in one field I want the next field to automatically populate 10 days later. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automatically populate date field in access97
- Thread starter L1Paquette
- Start date
- Status
I think you mean that the value of the second date field is 10 days after the date entered in the first field.
If you are using a form to populate the first field, you could have a macro that fills in the other field on the AfterUpdate event of the first field's control.
If you are not using a form, you could creat and run an update query that will set the value of the second date field.
If you are using a form to populate the first field, you could have a macro that fills in the other field on the AfterUpdate event of the first field's control.
If you are not using a form, you could creat and run an update query that will set the value of the second date field.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question