Follow Up Date

J

Jose Aleman

Hi,

I have a follow up field that I want an automatic date after a loan has been
received.

For Example:
LOAN_REC_DATE FOLLOW_UP_DATE
01/01/2006 01/05/2005

The follow up date needs to be 5 or 10 days after the receive date. It's
easy for the user to enter the date but sometime they forget or don't want to
count days. I want access to assign the date for them automatically.

Thanks
 
L

ldiaz

put something like this in your field:

[ FOLLOW_UP_DATE] = [LOAN_REC_DATE]+10 ' if you want 10 day after
[ FOLLOW_UP_DATE] = [LOAN_REC_DATE]+5 ' if you want 5 day after


if my answer was correct clicl YES in:

""""Was this post helpful to you?"""

Thanks
ldiaz
 
L

ldiaz

you need to put just this in your form field named "FOLLOW_UP_DATE":
[LOAN_REC_DATE]+10 or
[LOAN_REC_DATE]+5

I put this, to let you know what this formula makes..
[FOLLOW_UP_DATE] = [LOAN_REC_DATE]+10

where [FOLLOW_UP_DATE] is the fieed where it needs to go this
statements:[LOAN_REC_DATE]+10

Thanks
ldiaz

Jose Aleman said:
I wrote your command under Default Value and I see the following the field.
#Error

I also wrote it under After Update as a procedure but it didn't work.

Do you think I should create the form based on a query instead?
ldiaz said:
put something like this in your field:

[ FOLLOW_UP_DATE] = [LOAN_REC_DATE]+10 ' if you want 10 day after
[ FOLLOW_UP_DATE] = [LOAN_REC_DATE]+5 ' if you want 5 day after


if my answer was correct clicl YES in:

""""Was this post helpful to you?"""

Thanks
ldiaz



Jose Aleman said:
Hi,

I have a follow up field that I want an automatic date after a loan has been
received.

For Example:
LOAN_REC_DATE FOLLOW_UP_DATE
01/01/2006 01/05/2005

The follow up date needs to be 5 or 10 days after the receive date. It's
easy for the user to enter the date but sometime they forget or don't want to
count days. I want access to assign the date for them automatically.

Thanks
Click to expand...
Click to expand...
Click to expand...
 
J

Jose Aleman

I wrote your command under Default Value and I see the following the field.
#Error

I also wrote it under After Update as a procedure but it didn't work.

Do you think I should create the form based on a query instead?
ldiaz said:
put something like this in your field:

[ FOLLOW_UP_DATE] = [LOAN_REC_DATE]+10 ' if you want 10 day after
[ FOLLOW_UP_DATE] = [LOAN_REC_DATE]+5 ' if you want 5 day after


if my answer was correct clicl YES in:

""""Was this post helpful to you?"""

Thanks
ldiaz



Jose Aleman said:
Hi,

I have a follow up field that I want an automatic date after a loan has been
received.

For Example:
LOAN_REC_DATE FOLLOW_UP_DATE
01/01/2006 01/05/2005

The follow up date needs to be 5 or 10 days after the receive date. It's
easy for the user to enter the date but sometime they forget or don't want to
count days. I want access to assign the date for them automatically.

Thanks
Click to expand...
Click to expand...
 
J

John Vinson

Hi,

I have a follow up field that I want an automatic date after a loan has been
received.

For Example:
LOAN_REC_DATE FOLLOW_UP_DATE
01/01/2006 01/05/2005

The follow up date needs to be 5 or 10 days after the receive date. It's
easy for the user to enter the date but sometime they forget or don't want to
count days. I want access to assign the date for them automatically.

Thanks
Click to expand...

How do you decide whether it's 5 or 10 days? Is there some other field
in the table which determines this, such as the LoanType? If so, try
putting a Textbox on the form with a Control Source

=DateAdd("d", IIF([LoanType] = "Foo", 5, 10), [Loan_Rec_Date])


John W. Vinson[MVP]
 
Top