Value on Dates to change auto

  • Thread starter Thread starter Jerry A
  • Start date Start date
J

Jerry A

My form has a Friday ending date...the 4 days previous
dates are to auto fill from that Week Ending Friday date
to the other 4 date boxes...
end result is to have the dates fill in automatically
once the Friday date is inserted...
 
My form has a Friday ending date...the 4 days previous
dates are to auto fill from that Week Ending Friday date
to the other 4 date boxes...
end result is to have the dates fill in automatically
once the Friday date is inserted...
Click to expand...

Do you have a question, Jerry?
 
Question: What are the values I need to insert to get
those dates to automatically fill in from the friday date
entered on the form?
 
In the AfterUpdate event of the textbox associated with Friday's date, put
logic which uses the DateAdd function to figure out what the appropriate
dates are and populate the other text boxes.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)
 
Question: What are the values I need to insert to get
those dates to automatically fill in from the friday date
entered on the form?
Click to expand...

Try

DateAdd("d", -4, [FridayDate])

for Monday, and similarly for the others.

Note that these dates probably should NOT be stored in your table, if
they can be reliably calculated from the stored Friday date.
 
Back
Top