Conditional formatting - what to do when no condition exists

[RogerC]

I'm using the following code to change the color of a box in a report based on the results of a query. It works great as long as the query returns at least one record. However, sometimes the query will not return any records (and shouldn't). In this case, I need the formatting code to be ignored. Can anyone help me understand how to do this?

Private Sub Format_Box(Cancel As Integer, FormatCount As Integer)
If Event_Type = "CONFIRMED" Then
Box195.BackColor = 10787187
Else
Box195.BackColor = 11177338
End If

End Sub

 

[garyd1234]

Re: Conditional formatting - what to do when no condition ex

dump the results of the query into a recordset variable then check it
if rs.recordcount <> 0 then
do the formatting code stuff here
endif

 

[RogerC]

Re: Conditional formatting - what to do when no condition ex

Thanks garyd1234. I'm just a beginner with Access and have never created a recordset variable. I can't find anything about it in Help. Can you give me an idea of how to do this?