Need feedback on a design issue in a split form

[Pack10]

I am using a split form, one of the fields in the split form is a status field. When the user changes the status on the edit form, they would like to flip the color in the split form that shows the status field. This way they can see the status has changed,
what is the best design for this?

 

[Hap007]

If it is a continuous form, the you would use 'Conditional' formating

If it is not a continuous form, you could place VBA code in the on current property of the form to test and set the color and then on the 'AfterUpdate' of the field to also set the color

or, use Conditional formating.

Hope this Helps,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[Pack10]

OK, I got it to work, Not sure if i like the way I did it. I would like a more elegant way...if possible.

I created a table with 1 record in it. The status and reference #.
When they edit the record, if the status is different from what they entered, then I write the record to the table.

When the split form loads, in the status field I have added a function in the Conditional Formatting area. The function does a dlookup on the 1 record table retrieving the status and ref#.
Then in the Conditional Formatting it runs a function returning true if the record meets the criteria.