Highlight entire row (datasheet form) -- most previous change
Posted on 2004-09-28
I was wondering if it's possible to highlight an entire row (form; datasheet view) in which a change occured during previous action.
Let's say I have the following records:
Name Field_X Field_Y Total
Tom 50 5 32.0
Helen 20 10 16.0
John 24 4 16.0
Kathy 12 9 10.8
Don 14 3 9.6
The "Total" field is an expression based on the following calculation.
Total: CDbl(Nz([Field_X] * 0.6 + [Field_Y] * 0.4, 0))
a. The records are sorted by "Total" field
b. If a change occurs in "Field_X" or "Field_Y", the form is requeried; hence the records would be resorted based on new values in the "Total" field.
c. In the actual database, I have more than just the 2 fields (X & Y). I also have hundreds of records. So, potentially, a records that is currently "ranked" in the e.g. 1st position may be re-ranked to e.g. "75" position (dending on what values were selected in X or Y).
Here's what I want to see:
1. Again, as listed under c., a record may be re-ranked. At this time, it not easy to see as to how the change in X or Y has affected the record.
2. Therefore, it would be tremensdously helpful to highlight e.g. the record "Tom" (entire row in datasheet) if indeed I made a change in record "Tom" during the most previous action. Then, I could scroll down, realize that record "Tom" has now a rank of "75". As of right now, I would have to actually search for "Tom" ... which I don't want.
- if there's another alternative to "highlighting entire row", it certainly would be acceptable. I'm not too hard on this... even though, I think it would be easy to recognize
- whatever approach is chosen, I want to make sure that performance won't be affected too much by much. I recently learned that using the DCOUNT function has a tremendous (negative) impact on performance... [certainly, this is not to say that DCOUNT is the right approach].