[AccessD] Expiration Date

If you mean you navigate to other records and they show that, then your
expired label isn't being required properly, even if the date
calculation may be.

 
Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis,
Virginia
Sent: Tuesday, October 27, 2009 11:24 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Expiration Date

No. It is a Single Form. 

 
***
Is this on a continuous form?
 
***
On Tue, Oct 27, 2009 at 10:57 AM, Hollis, Virginia <hollisvj at
pgdp.usec.com <http://databaseadvisors.com/mailman/listinfo/accessd> >
wrote:
> Still doesn't work correctly. If I hit a record that is Expired all
the
> other records show Expired even if they aren't.
> 
> Would it work better if I used a Select Case? Would that have
something
> to do with it?
> 
> **************
> 
> I'd keep it in the OnCurrent event.
> 
> Use NZ() and some future date
> 
>  'DateEarlyExp.value =
> DateDiff('d',Date(),NZ([DateEarlyExp],DATE()+365))