Re: Default value question for dates
From: Michael P. Stein <mstein_at_access.digex.net>
Date: 11 Aug 1993 13:17:04 -0400
Message-ID: <24b9ig$e9d_at_access.digex.net>
Date: 11 Aug 1993 13:17:04 -0400
Message-ID: <24b9ig$e9d_at_access.digex.net>
The solutions previously recommended have the side-effect of causing the record to be marked as changed if the field being set is a database field. Thus attempting to exit without user type-in may still result in the 'Do you wish to commit' question.
This can be avoided by creating a control block with a date field on page 0, setting this field to SYSDATE + 365 in PRE-FORM, and setting the desired field to take its default from the control block field.
-- Mike Stein The above represents the Absolute Truth. POB 10420 Therefore it cannot possibly be the official Arlington, VA 22210 position of my employer.Received on Wed Aug 11 1993 - 19:17:04 CEST