Report/Subform Query Frustration

[roaml]

Hello All,

I have a report that has a subform.
I would like to select a site manger from a combo list and open a report for the selected manager.
I have this working with a macro fine, but I would like for the report to open with one record only.

I am trying to create a generic report that opens with the selected site manager (from combo list).
When the report opens, it will have the selected site manager displayed in the site manager field.
The body of the report will include some generic instructions then list the data from the subform as created in the link master and child fields.
So far I am able to perform all of the above except the report opens with ALL of the records associated with the selected site manager.
I am trying to get the report to open with just one page, as if I was working in a Word document.
Can someone please give me some ideas on how to achieve this report problem?

Thanks a bunch!!

 

[randysmid]

Hi,
It may be best to create a form that has your selected records based on ALL of the records associated with the selected site manager. These records would appear in a listbox with the "Multi Select" property set to "simple". This lets the user select one or more records. Based on this, you can use "filter" to select only the items the user wants to see in the report. See [faq-703-2657] to see how to set up a multiple selection filter condition.

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association