Need Help changing text in a field

[travismp]

If Me!Color = "RED" And Me!State= "NY" Then
    Me!Color = "STOP"
End If

This is on a report, on format. I am trying to update a field based of off information from 2 different fields. This of course breaks. The top code is correct, but I am not sure how to update the field while the report is open. What do I need to change on the bottom line? Thanks

 

[boblarson]

Instead of using code why not use an IIF as the recordsource for your control:

=IIf([Color]="Red" And [State]="NY", "STOP",[Color])

 

[travismp]

thank you Bob. I was able to use what you gave me at the query level to make this work. THANKS again, I have my report working perfectly!

Your help is always a big help. keep up the good work!

T~