Conditional Formatting based on a Count

[blongmire]

Hi All,

I have a sub-form where I'd like to set conditional formatting based on how many times that records ID shows up in a separate table. I'm running into a problem as the conditional formatting only wants to look at the first record in the table, and I'm displaying multiple records in my sub-form.

Any ideas?

Thanks,

Bob

 

[blongmire]

Hi Gang,

I was able to solve this on my own. I'm not sure if this is the best solution, but it is working smoothly.

I created a query to count the value for all records. Then, I created another table to house the results of that query (as when I tried to include the summary count results on my form it made the record set not updatable). Finally, I created queries to upend the query results onto the new table and then update the counted value back to my original table (once that process was complete I delete the appended results from the new table). I was then able to pull that value onto my form for conditional formatting purposes.

All in all it works great, but probably isn't the best practice. If anyone has any better ideas, I'm all ears.

Thanks!

Bob

I