Add Record, Change Record, Delete Record

[Ricky]

I have a data entry form which my CSRs are tracking customer information. I would like to have the information stored based on 3 actions Add, Change and Delete. I have a table (master) with your typical customer information fields plus master.datechanged master.datedeleted and master.introdate.

I envision when a user makes a change to a record, the record is updated and then a date in inserted into the master.datechanged field for that record.

Anyone have ideas on how this could be accomplished?

 

[Pat Hartman]

In the BeforeUpdate event of the form, place the code to update the update date and updated by fields.

Me.UpdatedBy = CurrentUser()
Me.LstUpdtDt = Now()

To update the Created by fields, put defaults in the table design.

 

[Ricky]

Thanks for the reply. I have changed the forms around a bit to only allow new in one form, to change or delete they need to access another form. In this scenario

Me.UpdatedBy = CurrentUser()
Me.LstUpdtDt = Now()

In the BeforeUpdate event would trigger regardless of Change or delete...Would there be a way either via a command button to populate the action field based on the actual action?