My brain is fried I think...
I thought I could easily do this by using an if statment and referencing the field on the report, but I get an error 2424 "The expression you entered has a field, control, or property name that Microsoft Access can't find."
I wont be able to do this will I? At least not the way I am thinking.
On the report open event I put
If me.txtamt.value = 0 then
me.imgred.visible = true
end if
Will I have to create a recordset based off the original query to get the value of the field and use that variable to set the image?