It came to pass on 12/05/96 that CINDY CHEEK wrote concerning Edit/Create...
CC> I need two dates to appear in each record of a certain form.
CC> The first date will appear once and stay unchanged forever; the
CC> created date.
CC> The 2nd date will be a changing date but will change only when that
CC> record is edited; the edited date. (hopefully entered
CC> automatically).
CC> Does anyone know if this is possible?
The second date is easy... Just have the field on the form, locked and
disabled (even invisible if you like). In the OnUpdate Event, put the
value of the date in the field.
The first date is similar, except you will have to check for an empty
field, and if it is empty put the date in. If it is not, then don't.
Did you get that? The specifics I don't know because I don't keep this
stuff in my head. But I do have this function of a DB I work on at
work.
Cya Matt __ _ ____ ____
---+=| =\|=| ==| ===) =========| ===' =============+---
matthewj@gil.com.au |_|\__|ew |_|\_\esolution |____,ommunications
* RM 1.31 3332 * Am I ignorant or apathetic? I don't know and don't care!
---
(3:640/404)
---------------
* Origin: Past the Black Stump BBS 07-54-656667 Laidley.. Q'land.
|