I am looking to add a notification field or conditional formatting in a continuous form that is based on underlying data or data from a query. I have a continuous form where each line is a summary of multiple lines. I need a way to determine if any of the lines that make up the summary have a different code in it.
For example the summary line is composed of five detailed lines. In each detailed line there is a field called rcode. Most of the rcodes will be 1 but sometimes it will have a 6. I need a way to set up some field or color notification in the summary line if any of the underlying rcodes are a 6.
I am not sure how to do this but I was thinking of running a query that returns a result if any of the rcode fields is a six and a different result if none of them are six. OR maybe a DLookup could do it.
Does anyone have an idea for this?
Thanks