Thanks. I was linking the subreport to a value that was not unique.

Hi

I have a subreport in the report footer of a report. When viewed in report view the subreport and data appear. In print preview only the subreport text label appears. There are additional controls in the footer and they print. The Display property is set to ALWAYS. HELP!

-Julia

I know it's been a long time but I'm ready to get back to this issue. I have 3 controls in the header to filter my form (Project Name keyword, type, and year). I have a button with the on click event code shown below to filter the form. I need to add a combo box for community and a combo box for flooding source to filter by. These two relations are as discussed previously. There can be a project with many communities and flooding sources. These values...

Ok, my first priority is to filter my form based on combo box values. I can look at the cascading part after.

I have a table called projects and it has fields 'project_id', 'effective_date ', 'issued_date', 'name', and 'type'. Each project could be related to multiple rivers and communities. I have a table for each: a river table that has fields 'river_id' and 'river' and a community table that has fields 'community_id' and 'community'....

I need to use unbound controls in a form header to filter a form. There is a very well written insight that describes filtering forms with unbound controls in the form header. (http://bytes.com/topic/access/insigh...form-filtering) However, it clearly states that the example is simple and does not include subforms. My form has two subforms each with a single combo box control. I need to filter records in my form based on values in...