Help from MS Access GURU'S ONLY! EXACT CODE NEEDED!!

[MsPeppa]

Hi, I say this question is for guru's only because I need EXACT code. I'm a newbie to Access and have been trying to solve this problem, which seems very simple for months now, and it's holding my project back. Here is the issue.

I have a report called "MainGeneral" I also have a subreport in "MainGeneral" called "Victim". This report is formatted, meaning when the user prints it out it contains borders, labels etc...to make it look like a professional reoprt. What is happening is if "Victim" contains no data then the subreport does not appear on "Main General" leaving an empty space. What code do I need to write exactly so that no matter if there's data in victim or not, tha the labels appear (note: Victim contains many labels) people have suggested using IsNull, and DCount but those did not work out. So please could someone help me with the code I need to write to make this work, or the properties I need to set. I will also need to know where to put this. I was not sure if I was to put the code under the Victim Form under "On Open" or on the General form under "On Open" Thanks GURU'S in advance...I have another question lol that I will be posting in another thread.

 

[RichUK]

Look in the help for HasData, there are examples of how to use it