Report if True?

[disneyplace]

I've got a report based on a table. The table contains 2 fields, Location and a True/False field. If the check box is true, I want the data from the location field to be displayed in the report, if not, don't display it??

TIA

 

[BukHix]

Something like this should work for you:

DoCmd.OpenReport "ReportName", acViewPreview, , _
        "[IsTrue] =" & True

Replace the IsTrue with the field name you are using for the check box and your report will open showing the only the true fields.

 

[disneyplace]

Thanks, I'll give it a whirl soon!

TAC