Highlighting changes

[LindaBee]

Hi
I have a form where managers request for network access for their staff
sometimes after the initail request the staff may need exttra access options
adding on, an email is then sent to our team to action teh new changes.

Becuase they are adding or just changing the previous request we cannot tell
from looking at the form what the new changes are.

What I need is a way of seeing what the new request i.e the fields that have
been updated to be highlighted or something along those lines.

Is this possible or am I chasing a dream?

Thanks in advance

 

[Arvin Meyer [MVP]]

How do you plan on determining what's an old change and what's new?

Suppose I change a record twice, what happens?

OK so what I would do is to add a date/time field to the table. I'd then do
2 things. First, I'd use conditional formatting to change the color of a
textbox, or the row of textboxes, if the record was less than, say 2 days
old. At the beginning of each day, I'd run a report to show all changed rows
since the last business day.

 

[LindaBee]

Thanks Arvin
I have decided to use the time stamp so that I will look at the last change
and go by that

Linda