[AccessD] Expiration Date

Virginia, I'm sending you a sample I made for you offline.

On Tue, Oct 27, 2009 at 11:24 AM, Hollis, Virginia
<hollisvj at pgdp.usec.com> wrote:
> 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))
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>