Check Box on a Report

[gemini2]

I have a query the have certain condition code. I'm creating a repor
that I have to put a check box on. However I only want the check bo
to display on the the report when the condition_id on the record i
in(14,15,16). I tried coding the following in the expressio
builder but it didn't work
IIf(qryCondition_Past!condition_i
in(14,15,16)chkOutstanding.visible=true)
What am I doing wrong

 

[Graham R Seach]

Put your code in the form section's Format event:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
chkOutstanding.Visible = (condition_id = 14 or condition_id = 15 or
condition_id = 16)
End Sub

....assuming of course that condition_id is part of the report's dataset.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[gemini2]

I quess I should had mention that I was using one query for the repor
and another query that determine if the check box should be checked o
not. I tried combining the two query but when I did I lost data.
was thinking about trying a union join thereby, maintaining all th
data. Is there a easier way to use two diff source on a report an
then code what you gave in your reply