Displaying a status

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I am trying to create a Loan application tracker that prompts the user to
complete a particular task based on the status the application is in. For
EG...

User is waiting on the return of loan contracts from customer.

If status = "Waiting" and has been waiting for more than 3 days, then a
prompt some like "chase up contracts" is to appear in a box.

I was able to make this task work in Excel, however the formulae used in
Excell cannot be replicated in Access.

Hope some one can help me.

Regards
 
Sam said:
I am trying to create a Loan application tracker that prompts the user to
complete a particular task based on the status the application is in. For
EG...

User is waiting on the return of loan contracts from customer.

If status = "Waiting" and has been waiting for more than 3 days, then a
prompt some like "chase up contracts" is to appear in a box.
Click to expand...


Add a text box and set its control source expression to:

=IIf(Status = "Waiting", "chase up contracts", Null)
 
Back
Top