Get the "Most recently changed control on a form" and update my textbox with it. How?

[MsLady]

Get the "Most recently changed control on a form" and update my textbox with it. How?

I need a code to fill a control on my form txtLastUpdatedControl with the name of the control that was last updated on the form.
What i am trying to accomplish is that, since most people go onto the form to make changes, i'd like to record the username (i have this working) and the last control they updated.
How do i accomplish this thru vba?

 

[MsLady]

*ahem Hello friends

 

[nikkypickles]

Hello MsLady,

I found something that seems to work - try doing a search for AuditTrail.

This might not be exactly what you are looking for, but it does seem to match most of your criteria

 

[KeithG]

To do this you would need to write code in all of your controls after_update event to update the text box with the name of the control just updated

 

[MsLady]

Hello MsLady,

I found something that seems to work - try doing a search for AuditTrail.

This might not be exactly what you are looking for, but it does seem to match most of your criteria

HI nikky, thank you i'll do just that. will let you know

 

[MsLady]

To do this you would need to write code in all of your controls after_update event to update the text box with the name of the control just updated

i have a very busy form

 

[KeithG]

I believe that is the only way you are going to accomplish this task. You would just need one line of code in each after_update event.

me.txtLastUpdatedControl="ControlName"