Help with Dates

[woknick]

I have two textboxes txtPrep and txtInstall.
When the user enters an install date, I would like the txtPrep to display the txtdate - 5 days.

So if txtInstall = 10/6/2004 Prep date would = 10/1/2004

Thanks in advance

 

[KenHigg]

me!txtPrep = DateAdd("d",-5,me!txtInstall)

???
kh

 

[Rich]

You're not storing the value are you?

 

[woknick]

both textboxes are conected to fields in a table

 

[KenHigg]

Will this -5 always be the case or will you need to maually change it to something else from time to time?

kh

 

[woknick]

-5 will always be the case

 

[Rich]

prep date is a calculated value and should not be stored. You can retrieve the value at any time via a query or calculated control

 

[KenHigg]

-5 will always be the case

Then Capt Rich's advice would indeed be prudent!

kh