flag change on form

[hs_1]

I have limited knowledge in programming, wonder if you can help me. I created form based on table which I update running update query. The table has few columns DwgNo, REV, REV_CHANGE, and Check Box REV_CHANGE_CLEAR. This is what I am trying to accomplish.
After I run update query if REV column value changes I would like to have:
DwgNo, change back color to red
REV_CHANGE, have value “Y” entered
After I review the changes to DwgNo I would like to be able to click on REV_CHANGE_CLEAR, change DwgNo back to #FFFFFF and REV_CHANGE to null value.
Thanks :banghead:

 

[James Deckert]

Your update query will need to set REV_CHANGE to 'Y' and you can set a background color based on the value in REV_CHANGE in the Format>Conditional Formatting

What is the point of REV_CHANGE_CLEAR, if it just blanks out REV_CHANGE, why not just blank it out yourself. If you want to do it in code, then your after update event for REV_CHANGE_CLEAR would set REV_CHANGE="", but the conditional formatting will take care of the color. If it doesn't change immediately, then an F5 (refresh) will repaint the screen.