hide subreport if no data

[AccessIdiot]

I have a report of survey areas. Some of the survey areas have cultural artifacts, some don't. I need to show all survey areas whether they have artifacts or not. However, I only want to show data about the artifacts if they exist.

Main report = survey areas
Subreport = artifacts

I'd like the subreport not to show up if there aren't artifacts in a survey area. Right now I see empty fields and headings.

In other words, I need to show all customer data, but I only need to show the details of their orders if they exist.

The Can Grow/Can Shrink thing didn't work for me. Putting Cancel() or visible = false on the subreports nodata event didn't work for me either.

Ideas?

[AccessIdiot]

More info.

tbl_Artifact.su rvey_id = tbl_SURVEY.surv ey_id.

So every record in the Artifact table is linked to a survey_id but not every survey is linked to an Artifact.