John, Could use something like this placed in the On Format event of the detail section in your
report (Air Code)
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim intX as Integer
intX = DCount("[recordID]", "RecordTable", "[recordID] = " & Me.recordID)
If intX > 0 Then
Me.Detail.BackColor = 65535
Else
Me.Detail.BackColor = 16777215
End If
End Sub
--
Reggie
----------
"John" <so*********@hotmail.com> wrote in message
news:90**************************@posting.google.c om...
My report is based off of a table. I need a record on the report to be
highlighted if that record ID is in a different table. Something like,
if record ID exists in Query X, then conditional format this entry on
the report.
Any suggestions?