Pushing filtered data from a form into a report (preview)

[Rightfield48]

Rookie who messes with Access to help manage data.....but is at a little loss on how to do a couple simple things...this is one....

Never had a class, but I've managed to build some forms/subforms where I actively use a variety of means to sort and select data. Instead of "printing" the form or the subform, I've created a report (that looks nicer than the form). How can I send the filtered results from the form to a report?

Background: I use a couple forms to select the "case" I want where the case number is [OID]. Once I'm in the "case" through a variety of means, I select the data in that case using a variety of selects, including right-clicking on a field and doing things like Select if contains the number 4. Once I get the data on the form (it's a subform) that I want to print, how do I easily get it into the report?

In this form, I used the variable "stLinkFilter" to selects data based on "a case". When I run it without the "me.filter" I get all the data in the case. When I run it without "me.filter" I still get all the data in the case regardless of what's contained in the list in the subform? How can I just get the data I've selected in the form?

DoCmd.OpenReport "reportname", acViewPreview, , stLinkFilter, , me.filter

[June7]

What do you mean by you select the data for form by a variety of selects - comboboxes? Are controls UNBOUND and used just to select filter criteria? Is this criteria applied to form?

stLinkFilter should apply filter to report. What is content? Me.filter does nothing and makes no sense in that argument position. Possibly could use Me.Filter in place of stLinkFilter.

If you want to provide db for analysis, follow instructions at bottom of my post.

[Rightfield48]

Thank you for responding. The file is 354MB after compacting so attaching it is probably not viable.

How can I save the current set of data into stLinkCriteria so that my report uses the same data as the form? My wife is calling me to dinner, I can write more later if that's helpful.

[June7]

You could make a database that has only the objects needed for the issue and only a few records.

The attached tutorial can probably explain building criteria better than I can in post http://allenbrowne.com/ser-62.html