I Enjoyed your video on conditional formatting for duplicates. It was perfect for what I need. However, I noticed that if I filter or add criteria to the query then the numbers don't adjust to the filtered query. For example, if I adjust the criteria to show a shorter date range the DCOUNT function doesn't reduce its numbers to reflect the smaller number of records. Is there a way to have the numbers reflect when the table/query is filtered further?
Yeah, this method doesn't take filters into consideration. But if, like Alex suggests, you change the underlying recordset, then it should work. In other words don't just filter the form, change the underlying query that it's based on.
Gregg Moore 5 months ago
Great I will try that and let you know. Sorry for taking so long to respond. I am not used to a tech help/support group being so quick to respond to my requests. Your group is WONDERFUL!