Date Time stamp for new record

[dweekley]

I am using the following for when a record is changed on the before update event.

'Information for who changed record
Me.CTS = Now()
Me.CTSuser = Environ("UserName")

What event would be used for an entry (new record)? I have tried before Insert, be doesn't seem to be the right one.

[Bulzie]

Before Insert should put the values in when you type the first character in a new record so that should work.

You could put those in the Default values for those fields for new records. Then when they are changed you would have it updated by the Before Update part.

Another way is in the AfterUpdate of another field on your form, set those values when that field gets updated. Needs to be a required field that has to have a value.

[dweekley]

Thank you. Reading the definition got me thinking.