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