J
Jenny Barker
With your help, I have designed a transaction log that allows me to trace
changes to records. I've also designed a report that is printed when the
changes are made - the report gets its records from a (2nd) temp table that
holds the changes made by the current user, then empties itself on the form
close (that way only the current changes are included on the report). So far
so good. The last improvement I'd like to make to the report is to highlight
the changed fields. The "EditTo" record would compare field by field to the
"EditFrom" record - if the fields aren't equal, then "EditTo"
[field].FontBold = True. My thought is to write a procedure that would do
something like:
If audType = "EditFrom" Then
strField1 = [field1]
strField2 = [field2] (etc)
Else (there are only 2 audTypes, so it must be a "EditTo" record)
If [field1] = strField1 then
[field1].FontBold = False
End If
I guess I'm looking for a shove in the right direction. Does this seem
reasonable? Also, I'm not sure how to structure the if statement that makes
the field bold - the user may change multiple fields & I want to make sure
all the changed fields are highlighted. Any advice/suggestions are welcomed!
Thanks in advance.
changes to records. I've also designed a report that is printed when the
changes are made - the report gets its records from a (2nd) temp table that
holds the changes made by the current user, then empties itself on the form
close (that way only the current changes are included on the report). So far
so good. The last improvement I'd like to make to the report is to highlight
the changed fields. The "EditTo" record would compare field by field to the
"EditFrom" record - if the fields aren't equal, then "EditTo"
[field].FontBold = True. My thought is to write a procedure that would do
something like:
If audType = "EditFrom" Then
strField1 = [field1]
strField2 = [field2] (etc)
Else (there are only 2 audTypes, so it must be a "EditTo" record)
If [field1] = strField1 then
[field1].FontBold = False
End If
I guess I'm looking for a shove in the right direction. Does this seem
reasonable? Also, I'm not sure how to structure the if statement that makes
the field bold - the user may change multiple fields & I want to make sure
all the changed fields are highlighted. Any advice/suggestions are welcomed!
Thanks in advance.