Continuous Forms Problem

[Haynesey]

Hi,

I am designing a call logging database. I have my form set to continuous forms so that all calls are listed and are easy to view. Should a call expire, I want an indicator to show to inform the user. This works fine when using a single form, but when using continuous forms, either all or none of the records show the indicator. Is there any way round this?

Many thanks in advance
Lee

 

[Rich]

You haven't told us how you decide when a call has expired, so I'll guess that it's based on some date criteria, say two days after the call, add an unbound textbox to the form, set the control source to =Iif([MyDateField]<DateAdd("d",-2,Date()),"Expired"," ")

 

[Haynesey]

Thanks Rich

Hi Rich,

That works brilliantly. However, I only want Expired to appear if another field called ‘Call Type’ is set to either Type1 or Type2. If ‘Call Type’ is set to anything else, the Expired should not appear, even if it has gone passed the number of days?

Is this a similar thing to do?

Thanks again
Lee

 

[Rich]

=IIf([Call Type] In ("Type1","Type2"),"Expired"," ")