Sure, it's just a matter of tying how you display it to how you save it. I have a cab reservation/dispatch system. If you pull up a reservation, it will display a subform of its history at the bottom (reservation taken, dispatched, any audit data). The audit/history table includes reservation number, so the subform is tied to the main form via master/child links.
I wonder if I can get it into mine but add in the user name, task id number, changes made.
Make it have a pop-up on the form's 'on open' event which says, 'This task was last edited on XX/XX/XXX by user name" **This would just be like a dialog box that says the information and the user can just click 'ok' and it'll take them back to the task for them to edit it.
**This ONLY shows when a task that is "old" rather than a brand new task.
It works, some what, it puts in the date, time, user name.
**It doesn't do the following which I need to have done**
However, I'm trying to get it to put in the Task_ID number that was opened/changed/edited PLUS I'm trying to get it to record the changes that were made, like the individual changes (ie: date addition, notes added, status change, etc).
For starters, I don't see how that puts in "date, time, user name". It appears to put in user name and task ID. You're not doing anything wrong per se, you're simply not passing the additional information. You might look at the OldValue property of bound controls. Maybe this call to an audit function will give you some ideas:
That is why it shows the date and time, it's done automatically.
Now I added : User_Name, Action, Task_ID
There it puts in the actual user name (fOSUserName) and for Action it says " Record Update: 17 " with Task_ID being blank / a zero value
So for the most part, it's ok. I just need to figure out how to capture the actual Task_ID number that is begun / edited and the actions taken within the task, or any / all of the controls on the form, frmTask, which are changed or edited.