Update field on field change

[Zeroanarchy]

Trying to keep a log of what user are doing when running the program,

Have 2 forms
1. is a log in form that captures there name and then hides.
2. is a customer data entry form.

I am having no problems with attaching the users name to a new entry but are unable to work out how to attach it to a record they are editing. I need to be able to force there name into a field called "Login change" when they edit any information in edit mode I need to be able to hav it update or edit the old details and replace them with new details


example:
Name : Jo Smith ---- Add mode ---- Enter name into database
Name : Jo Smith ---- Edit mode --- ????

Thanks for help on this one..

Ta
Zero Anarchy

 

[purpleflash]

You could try this
On the before update event of the customer data entry form

Me![Login change].DefaultValue = [hiddenform]![namefield]

!

 

[MichaelRed]

See faq181-291 it is a process which captures all changes made via a form. It use/expects the security module "UserName" variable, but it should be adaptable to your purpose.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over