[b]NEED TO KNOW HOW TO CREATE FORM MODIFICATION LOG[/b]

[blue1914mab]

I have a button on a form that when clicked, updates the status, date stamps, and post the current user who has been assigend that record. I need to be able to keep a log, like the "Name Auto Correct Log" that shows every time that button has been selected, along with date, and user who clicked it.

 

[Sashanan2]

I'd create a table for that log (with columns for user and date/time) and use VBA code and an INSERT query to write a record to it every time the button was clicked. For date, you could use the Now() function; for the user, Environ("Username").

By the way, please don't use all caps for your topic titles. I realize you want your topic to stand out, but then everybody wants that. Just use informative topic titles (yours was fine) and that'll draw viewers by itself, whereas the use of all caps might drive them away.

"Any fool can defend his or her mistakes; and most fools do." -- Dale Carnegie

 

[genaccess]

I am assuming what you want is an audit trail. You can find many threads on Audit Trail. Use the search feature of this form and you will find FAQ's and threads full of VBA codes that you can implement in your database