Updates

[cunnie76]

Help!

How do I....

On a particular form I have approx. 50 Fields. What I want to be able to do is to monitor when a particular field has been changed, i.e. who changed it and when.

That is to say, Out of the 50 fields there is one field in particular that is vitally important - and so I am keen on putting a flag on that particular field.

Only when the data in that field has changed, does the UserID and date appear.

Also I want the details of user and date to appear on a connected report - can I do this?

Can anyone please help?

Thanks,
Bob

 

[Agism]

I am not certain if this is the best way, but this is what I did.

I actually wanted to know when a user changed the data in any field in the form so I locked all fields. When a user wanted to edit data, they selected an edit button.

The on-click even of that button opened a form where the user was required to enter what they were doing. (I suppose you could put this on the on-click event of the field you were wanting to track.) The CurrentUser and date automatically populated the fields when the user began to add the reasons for the change. Maybe someone could tell you how you could, or if you could, auto-populate the field name on the changes form.

Once the information was added to the changes form, a second form would open with only that record in it where every field is updatable.

Like I said, I don't know if this is the best way, but it is one that I could sort out for our uses.