Simple Date Question.

[radink]

I want to be able to fill in a field with a date and then have another
locked field update with the date 2 weeks later.

I'm sure this is doable, but I can't seem to figure it out.

Thanks

[fredg]

Re: Simple Date Question.

On 15 Jan 2007 08:54:01 -0800, radink wrote:

I want to be able to fill in a field with a date and then have another
locked field update with the date 2 weeks later.
>
I'm sure this is doable, but I can't seem to figure it out.
>
Thanks

On your form (not in a table), add an unbound text control.
Set it's control source to:
= DateAdd("ww",2,[DateField])

This value need not be stored in a table. Anytime you need the value,
re-calculate it, as above.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[radink]

Re: Simple Date Question.

Thanks!!


fredg wrote:

On 15 Jan 2007 08:54:01 -0800, radink wrote:
>

I want to be able to fill in a field with a date and then have another
locked field update with the date 2 weeks later.

I'm sure this is doable, but I can't seem to figure it out.

Thanks

>
On your form (not in a table), add an unbound text control.
Set it's control source to:
= DateAdd("ww",2,[DateField])
>
This value need not be stored in a table. Anytime you need the value,
re-calculate it, as above.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail