I'm working on a database to keep tracking of products going in and out.
Most it works as I want it but there is one thing that I have not been able to implement yet.
I would like a field that changes in the current date when the record is changed to see when any thing has changed for this product. It is supposed to work with the DateModified function I remember from a long time ago, but can't exactly recall it.
I have a field called "Last Modified Date". In the table design view I would like to edit the "Default Value" but I can't figure out what to fill in here to get a modified date each time a record is changed.
You already have the field in table ("Last Modified Date") for each record. Do you have a bound TextBox on Form to this table field? If not...then do so. Set its visible property to False if you like so no one can see it (whatever).
Then in your Form's OnDirty Event perhaps have something like:
Private Sub Form_Dirty(Cancel As Integer)
Me.LastModifiedDate = Now()
Self Taught In ALL Environments.....And It Shows!