[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))