I have a form for the SalesLead table that has a disabled and locked text box that displays a SuggestedClient Name. I use conditional formatting to shade red any suggested ClientName (primary key) values that have no matching row in the Clients table (a different table from the record souce of the form). The expression counts the number of matching rows in the Clients table that match the SuggestedClient Name value and then subtracts 1. If there is...