Hi, I've attached an example database to explain better. I've got a DB full of complaints and a form that examines each complaint one by one. I'd like for the form to display a number of how many total complaints we have in the DB for the customer shown. In the example I have a DCount which shows all complaints in the query, but I can't seem to do the criteria piece right to have it zero in on the CustomerID listed in the current entry that is being viewed. I tried:
But that errored out. Any idea?Code:=DCount("*","qryComplaints","Me.CustomerID")