Re: auto date

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The default value is given to record only when u insert a new. For update the
value of 2 field, u must use
a code vba in event form "beforeupdate" where assigne now() to the field

Gerald wrote:
>I have 2 date field which automatically generates the date when the record is
>added
>one date is in tab strip 1 and other at tab strip 2 both has Now() function
>question is
>e.g. when I enter records in tab stip 1 the date field gives 26/11/05, two
>days later I enter records in tab stip 2 it gives the same date 26/11/05,
>I need 28/11/05 to automatically generated in date field of tabstrip 2
>
>help plz
>
>thanks

--
Message posted via http://www.accessmonster.com
.