Reporting to only include indicated data criteria from a Query Filter

[Boost]

Hi there, with the assistance of many forum members I have implemented an advance search form into my db.



The advance search form was provided by Gicu - whose assistive thread can be located https://www.accessforums.net/showthread.php?t=72947 here.

The advance search form allows the user to select a particular query, then apply filters (<, >, <=,=, LIKE) etc. to narrow down the search results.

From here, ideally I want to try and construct a report that only utilises the selected criteria from the Advanced Search Form. I would also like to accomplish this task via VBA code held within a button on the form.

This is due to end-user requirements and/for people who won't understand the report wizard etc.

Any help would be largely appreciated.

Kind Regards

Boost

[June7]

Save the constructed criteria somewhere (textbox, variable, TempVar). Use it in WHERE argument of OpenReport command.

[Boost]

Cool thanks for the response - I've started to look into what you recommended and have managed to link the text-box that contains the particular filter.

The text-box that contains the filter is called

txtFilter

, and its value changes depending on the user-inputted query.

How should my WHERE CONDITION look in my macro?

I constructed this so far (screenshot 2) but all that occurs is a pop-up that I have to re-enter the filter.

Any help would be appreciated!

Cheers

Boost

[June7]

I don't use macros, only VBA.

I think macro will require path like: Forms!formname![txtFilter]

[Boost]

What then should/could my VBA code look like? I'm more inclined to utilise VBA too...

[June7]

DoCmd.OpenReport "rpt_Advance_Reporting", acViewPreview, , Me.txtFilter