View Full Version : autodates in fields


topcat
01-24-2001, 12:09 PM
If I have an edit box that shows the date entered in field "WEEKSTART", and I want the edit box next to it to show "WEEKSTART" plus one day, how would I go about it?

I have tried various expressions but nothing has worked so far.

mrabrams
01-24-2001, 12:24 PM
Place in Controlsource for 2nd textbox:

=DateAdd("d",1,[WEEKSTART])

Michael Abrams

[This message has been edited by mrabrams (edited 01-24-2001).]

topcat
01-24-2001, 01:07 PM
Thanks.
I tried that without the inverted commas round the "d"... which is probably why it didn't work! 8-)
will have another bash at it!

Susan

The more you learn, the more you see how little you know......sigh