Value on Dates to change auto

[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...

 

[John Vinson]

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...

Do you have a question, Jerry?

 

[Jerry A.]

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?

 

[Douglas J. Steele]

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)

 

[John Vinson]

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?

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.