Database1.accdb

<div>
since it looks like your subform is based on a query, why not add a computed column (or multiple) to the query that evaluates to True or False, with respect to the critieria you use for each of the rows/columns which sets the color to red.<br />
<br />
Then you could run another query against that query to determine how many records meet your Red criteria for each of those columns.
</div>


since it looks like your subform is based on a query, why not add a computed column (or multiple) to the query that evaluates to True or False, with respect to the critieria you use for each of the rows/columns which sets the color to red.

Then you could run another query against that query to determine how many records meet your Red criteria for each of those columns.

<div>
John, Very nice ! Thank You.
</div>


<div>
<div class="content wysiwyg-content">
access 2010<br />
form<br />
subform<br />
<br />
I have a form called &quot;main&quot;<br />
subform called &quot;dbo_t_redbook_pricing_esc<wbr />alation_de<wbr />tail_subfo<wbr />rm&quot;<br />
<br />
I need to loop through 2 columns<br />
on the subform to see if my conditional formatting has changed the fore color/background color to red ?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/10_w42/1200363/FORMATTING.png" target="_blank" title="background/fore color (9 KB)"><img alt="background/fore color" class="file-block lazyload" style="max-width: 366px;" data-src="https://filedb.experts-exchange.com/incoming/2017/10_w42/1200363/FORMATTING.png" /></a><br />
if it does i need a msgbox or boolean alert.<br />
I will &nbsp;be calling the alert from a Command button on my main form.<br />
<br />
<br />
<br />
Thanks<br />
fordraiders
</div>
</div>


FORMATTING.png

access 2010
form
subform

I have a form called "main"
subform called "dbo_t_redbook_pricing_escalation_detail_subform"

I need to loop through 2 columns
on the subform to see if my conditional formatting has changed the fore color/background color to red ?



if it does i need a msgbox or boolean alert.
I will  be calling the alert from a Command button on my main form.



Thanks
fordraiders

looping through subform for specific  background color red and give me some type of alert

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.