In access 2007 I am trying to set a yes/no column to display a checkmark. The check is in reference to a currency value in another column. Both columns are within the same table.
In short, column A should display "A" check if column "B" has a value over $5,000.
 

---

Answer from Richard Rost:

Use an AfterUpdate event for when field B is updated.

You can use an AfterUpdate or BeforeUpdate event to set values, change properties, run macros, and do lots of other cool things.

The major difference between the two is that BeforeUpdate runs BEFORE the data is saved to the table, which allows you to CANCEL the update if the data is not valid. AfterUpdate runs after the data is saved to the table.

Please see the following FREE video tutorial on my web site for step-by-step instructions on how to create an AfterUpdate event:

http://599cd.com/tips/access/afterupdate-event-vba?key=BlFAlEx