Search results

I have the following code... Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strSQL As String Dim rs As DAO.Recordset Dim x As Integer Set db = CurrentDb Set qdf = db.QueryDefs("CNoteFullPage") strSQL = "Select * FROM CNotes WHERE CID = " & Form_PacketClients!RecordID & " ORDER BY NDate...

Ok so I have code that changes the border color of a form, it is a recordset of Notes for a client. The color changes based on if a person has a checkmark next to a "flagged" checkbox. Since it is a continous form it highlights every record if one is checked. What I want to do it highlight only...